How to integrate Power BI with Dynamics Business Central

Updated: Aug 13

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.

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

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

5. Click Power BI Reports drop-down arrow.

6. Click Select Report.

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

Check out your brand new Power BI enabled report:

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.

To manage reports, click Manage Report.

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

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.