Embedding a Power BI report into Dynamics 365 Business Central

Published on July 30, 2021

Interpreting a dataset with multiple views, a Power BI report provides visuals with multiple findings and insights. Depending on the type of data, there can be single visual or multiple pages of visuals. With an advantage of dynamic & interactive report, one can go beyond insights and get the exact answers. In this article, our Business Central consultants have drafted a process to embed Power BI report into the role center of Dynamics 365 Business Central.

Step 1: Install the Power BI desktop in your system

Step 2: In Power BI desktop, select More from the action ribbon and click on get data.

Embedding Power BI Reports In Business Central

Step 3: Select the Online Service and Click the Dynamics 365 Business central connector from the get data action.

Embedding Power BI Reports In Business Central-2

Step 4: Select sign in to connect your Business Central account and click Connect

Embedding Power BI Reports In Business Central-3

Step 5: Once it is connected, choose the environment of Business central that you can access

Embedding Power BI Reports In Business Central-4

Step 6: Choose the Company Name and the webservice list in the company will be shown.

Embedding Power BI Reports In Business Central-5

Step 7: Choose the Webservice that you want to access and Click Load

Embedding Power BI Reports In Business Central-6

Note: It will load the data from Business central to Power BI

Step 8: Once it is loaded, all the fields will be shown in field pane

Embedding Power BI Reports In Business Central-7

Embedding Power BI Reports In Business Central-8

  • The Visualizations pane, where you can add, change, or customize visualizations, and apply drill through
  • The Fields pane, which shows the available fields in your queries. You can drag these fields onto the canvas, the Filters pane, or the Visualizations pane to create or modify visualizations
  • The Filters pane, where you can filter data visualizations

Step 9: Create the Power BI report and Save it

Embedding Power BI Reports In Business Central-9

Step 10: Publish the Power BI report

Embedding Power BI Reports In Business Central-10

Step 11: Choose a workspace and Click Select

Embedding Power BI Reports In Business Central-11

Step 12: Once the report is published, a message will be displayed as shown below

Embedding Power BI Reports In Business Central-12

Step 13: Go to the Role centre of Business central

Embedding Power BI Reports In Business Central-13

Step 14: Choose Select report to view the report

Embedding Power BI Reports In Business Central-14

Step 15: Select the report that you have published in Power BI and Click OK

Embedding Power BI Reports In Business Central-15

Embedding Power BI Reports In Business Central-16

Embedding Power BI reports in Business Central can help to predict trends and patterns, and streamline operational efficiency. With the guidance of a experienced Business Central partner, harness the true power of data and make informed decisions.