Let’s get started.

In Power BI Desktop, select Get Data, More:

Authenticate using your Office 365 credentials (email & password), end then select a query:

In this case, I’m filtering the navigator on queries that contain the word item in their name, and then I select Edit to verify the query in the query editor:

Then I select the columns I’m interested in:

I then click Close & Apply to load the data.

Now comes the fun part, designing the report, by selecting some visuals and displaying the data:

Now comes the tricky part. You need to add a report filter containing the Pk (Item No), if you want to plugin this report on the Item List page:

And that’s it. Now save the report, and use the word Items in it’s name, because the list page probably filters on the report names containing Items, in the Power BI factbox on the Item list. (Customers if you want to do something similar on the Customer List)

Now, publish the report to your Power BI Service workspace:

Have a look at it:

Now go to Business Central, open the Item List and:

And voila:

To make sure it works correctly, I then added a card to the report, displaying the item description, and republished the report:


And of course you can make them swim too…

How cool is that!!!

Would you like to learn more? Then join my Power BI sessions at Directions Emea and NAV Techdays 😉

6 Thoughts on “How Do I: Add and Link a Power BI Report to a page in Business Central?

  1. If a company has multiple users, One user has power bi account, so If this user developed and published the report. Can other users see this report On business Central.

    • Hi Alay,
      yes and no 😉
      If you want to share, then you need a pro account and also everyone you share with also needs a pro account. Then they can embedd the reports in BC.

  2. Laura on April 19, 2019 at 13:56 said:

    Is it possible to add Power BI reports in the factbox on other list-pages than Items, Customers, Sales Orders et cetera? For example I’d like to show a PowerBI report on the Lot No. Information List in Business Central

  3. Aaron on June 4, 2019 at 20:40 said:

    Is there a way to have a Power BI that’s displayed in Business Central auto-recognize the Company that the User is logged into? If the Company using Business Central has multiple Companies for their different business entities, then it would great to have a Power BI recognize you are in the Cronus company and display that data. If the user switches to another company, then the report would display that company’s data.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Post Navigation