Power BI Reporting with Dynamics 365 Business Central
Alletec Blogger 1comment Blogs Read 1062 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

Empower your business with Dynamics 365 support, for more details, Click here: https://t.co/2w9CGhTiNo… https://t.co/nWntvRDvIp

Transform your manufacturing and supply chain operations with Dynamics 365 Supply Chain Management. For more detai… https://t.co/08vBN6bgCn

New pricing and licensing for Microsoft Dynamics 365 Unified Operations apps planned for October 2019 In October,… https://t.co/umSeKrWZPk

Nucleus Research recognizes Microsoft as a Leader in the 2019 ERP Value Matrix Learn why robust capabilities, flex… https://t.co/CnwWL1cSN3

Contact Address

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

Follow Us