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

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:

How cool is that!!!

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

Comment List