Power BI Reporting with Dynamics 365 Business Central
Alletec Blogger 1comment Blogs Read 629 times

Power BI Reporting with Dynamics 365 Business Central

Rate this item
(1 Vote)

One has to admit that with the Dynamics 365 offering, Microsoft has taken a big leap towards automating the majority of the business processes in any company. The combination of various applications in the Dynamics 365 stack provides an integrated solution coverage. These applications can talk to each other with ease and the integrations can be achieved with much lesser technical effort and challenges.

One such feature on the BI front is the ability to use Power BI for reporting along with Business Central. Dynamics 365 Business central has the capability to show Power BI reports inside, however, the question could be- Can we design our own reports with Business Central data using Power BI and access them from within Business Central?

As an example, this article covers the steps on how one can use Business Central as a Data source and build powerful Power BI Reports according to the business requirements. The Power BI report can then be embedded in Business Central, thereby completing the cycle.

What you need - a valid account with Dynamics 365 Business Central and Power BI Services. To start with, we can design report on Power BI Desktop and publish later on Power BI Services.

Now, let’s dive into the steps:

Power BI Report 

  •  Go to Get Data from the Menu and select Online Services - Microsoft Dynamics 365 Business Central – Connect

Power BI demo

  •  Sign-in into Dynamics 365 Business Central and connect

Power BI dashboard



Power BI and Business Central


  • Select Business Central company and data source to connect with from the Navigator

Power BI reports

  • Power BI displays the Navigator with the Web Services published in each company in D365 Business Central

Power BI dashboard

  • Select the Data to be added to the data model and select load. This will load the fields available in the Web Service Business Central Tables in Navigation section

Power BI reports using Business Central


Power Bi Business Central Integration



  • The connection is now set to Business Central and one can start designing the Power Bi Report using the tools and features available in Power BI



  • Complete the Power BI report (adding Table, Measures, Dimensions, Filters and Formatting) and publish on Power BI Services (Online) and then embed in Business Central instance. 



 Author: Gaurav Raj


About Alletec

Alletec has been a leading provider of Business Technology Solutions & IT Services to Growth Companies since 2000. Recognized consistently by Microsoft to be amongst their Top Microsoft Dynamics NAV/Business Central Partners, Alletec has been part of the global elite Microsoft Dynamics Inner Circle and President's Club. Working with customers in US, UK Hong Kong, Europe, India, Australia, Africa, and Middle-East, the company has helped companies across various industries in their Implementation and upgradation of Microsoft products. 



1 comment

posted by Jeffry
Friday, 26 July 2019 12:29

There are some interesting points in time in this article but I don't know if I see all of them center to heart. There is some validity but I will take hold opinion until I look into it further. Good article, thanks and we want more!

Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.

What is the sum of ?
More in this category:


Global Presence

latest from twitter

Thanksgiving is here!! It's time to Thank Everyone Around us For One More Blessed Year... #Thanksgivingday… https://t.co/tcgi10D7Qk

Microsoft shifts focus towards User Experience - Paradigm of customer-centric Azure portal development For more d… https://t.co/iIejfGtKr0

There’s a new, modern ribbon that aligns Power BI Desktop with Office and adds more functionality. To know about t… https://t.co/lJIS0qmimo

Learn how to make the optimum use of Microsoft Dynamics Azure On Premise coupled with Azure Cloud for complete peac… https://t.co/COfJKSNFbC

Contact Address

  A-1, Sector - 58, Noida - 201 301, India
  +91(0) 120 3000 300

Follow Us

joomla social media module