How to integrate Power BI with Dynamics 365 Business Central

Updated: Jan 4

Accurate and timely information is indispensable for any business owner in making informed decisions. Business leaders measure the success of their organization by comparing it against a set of Key Performance Indicators (KPI). You can easily track and visualize your KPIs using a business intelligence tool that you can integrate with your existing financial management system.


Such is the case of Microsoft Power BI, a self-service business intelligence tool that lets you discover insights and perform critical analysis of your business data. It’s powerful on its own, but it becomes even better when integrated into your other financial management application such as your Dynamics 365 Business Central (formerly NAV).


Steps to integrate Power BI with Dynamics 365 Business Central.


1. Log in and open Dynamics 365 Business Central.

2. Set this up per user. Update this per Business Central user.


How to integrate Power BI with Dynamics 365 Business Central

3. Click Get started with Power BI. Your Power BI license will then need to be verified.

How to integrate Power BI with Dynamics 365 Business Central

4. Next is the deployment of your Power BI Report.

How to integrate Power BI with Dynamics 365 Business Central

5. Click Power BI Reports drop-down arrow.

6. Click Select Report.

How to integrate Power BI with Dynamics 365 Business Central

7. Select the Reports that you need by clicking “Enabled”.

How to integrate Power BI with Dynamics 365 Business Central

Check out your brand new Power BI enabled report:

How to integrate Power BI with Dynamics 365 Business Central

Here's how to expand your Power BI enabled report.


1. Click Expand Report.

2. The report will be available to users based on the expanded report.

3. To navigate, click Next Report > Click Next Report.


How to integrate Power BI with Dynamics 365 Business Central


To manage reports, click Manage Report.

How to integrate Power BI with Dynamics 365 Business Central


The Power BI Management report will now be available to users.

How to integrate Power BI with Dynamics 365 Business Central

Still need more assistance with integrating your Power BI to Dynamics Business Central? Drop us a line here and we’ll be in touch or call 403 744 5358.