Power BI Reporting with Dynamics 365 Business Central
Alletec Blogger Be the first to comment! Blogs Read 2557 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


Related Topics:

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. 



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

Know how AI and Blockchain help in Master Data Management: https://t.co/yb1biFJLuC #AI #Blockchain #datamanagement @Forbes @Gartner_inc

Planning for #DigitalTransformation success. ☛Here’s a short video on our success story on #MSDyn365BC Implementati… https://t.co/sgblG5GNjm

Are you having a hard time deciding whether you should adopt Cloud or stay on-premise for your Microsoft Dynamics s… https://t.co/ojbKURiwod

Want to move from customizations to configurations? CYBORG - a business rule engine allows non-programmers to make… https://t.co/PDe4zhN9np

Contact Address

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

Follow Us