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:

Edit:

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 😉

2 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.

Leave a Reply

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

Post Navigation