31
Dec
18
Power BI Reporting with Dynamics 365 Business Central
Alletec Blogger 1comment Blogs Read 3306 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:

Partner



Global Presence
India
Australia
US
 

latest from twitter

On this auspicious day of Raksha Bandhan, celebrate the bond of sibling love and togetherness. Happy Rakhi to all… https://t.co/0542aEiJ4H

Saluting the supreme sacrifices of soldiers who laid their lives for the country. Alletec wishes you Happy 73rd Ind… https://t.co/PVIyHUj6Xx

“Freedom is not worth having if it does not include the freedom to make mistakes.” – Mahatma Gandhi At Alletec, emp… https://t.co/42SUkxVRy6

RT @MSDYN365BC: Tip of the day: Hover over a record variable to see a tooltip with the record fields, including type and whether it is a ke…

Contact Address

  A-1, Sector - 58, Noida - 201 301, India
  +91(0) 120 3000 300
  info@alletec.com

Follow Us

joomla social media module