Connect Power BI with Dynamics NAV through Dynamics NAV connector

  • Post category:Power BI
  • Post author:
  • Post published:March 17, 2020

Addend Analytics is a young and rapidly growing Data Analytics consultancy.  We specialize in the application of Business Intelligence and Data Science tools to solve business challenges. From our office in Mumbai, India, we provide end-to-end solutions to our global clients. These solutions involve data discovery & integration, data warehousing, analytics, and reporting. You can contact us at kamal.sharma@addendanalytics.com for free consultation!

In my new blog post, I will show how to connect Dynamics NAV through Dynamics NAV connector for Power BI.

Since the last few Power BI updates users must enter OData URL for each OData web services.

From the last few Power BI updates, we have available Dynamics NAV connector in Power BI.

This Dynamics NAV Connector is currently in beta, but to get them to just go to Get Data -> Dynamics NAV and choose Dynamics NAV (beta).

dynamics 365 data integration

In the new window, you will enter OData URL which we already used when connecting Dynamics NAV with PowerApps and Flow.

dynamics NAV

  1. OData URL – url specified for OData web services and who is available outside your network.
  2. Company – company name from Dynamics NAV.

When you fill all necessary fields click on OK and the new window will open

Window

On the left side of screen you will find all your pages and queries published in Dynamics NAV through web services, and on the right side you will find the preview of data source.

Clicking on Load, Power BI will get model and data from the Dynamics NAV database and you can start building your own Power BI reports.

Power BI report

Thank you for reading our blogs.