Admin Setup: Connecting Origami KPI web part to read data from PowerBI

[origami]

How to display Power BI data in the Origami KPI web part

To show data from Power BI in the Origami KPI web part, you’ll need to create a Power BI report in a specific format using the steps below.

We’ll use Microsoft Power BI Desktop, which you can download and install here: Power BI Desktop download.

1️⃣ Create the Power BI Report

1. Open Power BI Desktop.

2. Choose your data source.
   For this example, select Learn with sample data.
   

   

3. On the next screen, click Load sample data.

4. Select a table to use (we’ll select financials for this example) and click Load.
   

   

5. In the Visualizations pane in the right-hand side of the screen , select the Card visualization:
   

   

6. A blank card will appear on your report:
   

   

7. In the Data pane, click the checkbox next to a measure (for example, Gross Sales) you want to display in the card:
   

   

8. The card will display the selected value:
   

   

Tip: You can add multiple cards (steps 5–8) to show different KPIs: Here is how this will look like with 3 cards:

10. Click Publish in the ribbon to publish your report:
    

    

11. Save the report file locally and complete the publishing steps (choose your workspace, click Select).
    

    
    5. 6. 7. 8. 9. 6.

2️⃣ Get Report and Card URLs

Now you’ll grab the URLs needed for the Origami KPI web part:

1. Go to Power BI online.

2. Select the workspace where you published the report:
   

   

3. Open your report:
   

4. In the report, click File → Embed report → SharePoint Online:
   

   

5. Copy the Embed URL provided.

6. Go to the SharePoint page with your Origami KPI web part.
   Paste the Embed URL into the Power BI Report Embed URL field:
   

   

7. Back in Power BI, ensure you’re viewing the report in Reading view by clicking the reading view as shown below. If you don’t see the button, it means you’re already in reading view.
   

   

8. Click on the Card you want to show → click Share visual:
   

   

9. Paste the Card URL into the Value field of the Origami KPI web part:
   

   

10. Save the web part settings and publish the page.

3️⃣ Give all users Microsoft Fabric license

Microsoft Fabric is Microsoft’s all-in-one data analytics platform that combines tools like Power BI, Data Factory etc.

In order for other users to be able to see data coming from your PowerBI report, you will need to assign those users Microsoft Fabric license.

Here is what to do:

1. Go to https://admin.microsoft.com/ and log in with administrative rights
2. Click on the Users → Active users
3. Select the user and wait for the properties flyout to open
4. Under Licenses and apps category, find the Microsoft Fabric as shown below.

5. Check the box next to it and click Save changes

Your KPI web part will now display live data from your Power BI cards for applicable users!

Error codes:

Contact your admin to enable embed code creation

Did you get this error while trying to get the embed code for the report:

Steps for the Admin:

1. Go to Power BI Admin Portal.
2. Under Tenant settings, find Publish to web.
3. Set it to “Enabled” for the appropriate users or security groups.
4. Click Apply.