Microsoft Dynamics NAV content pack for Power BI
Starting from NAV 2016, Power BI has a special content pack for NAV (freely available) that contains ready-to-go dashboards and reports for NAV financials and sales data. You can find details about the Microsoft Dynamics NAV content pack for Power BI at https://powerbi.microsoft.com/en-us/integrations/microsoft-dynamics-nav/.
Let's see how we can use Microsoft Dynamics NAV content pack for Power BI by performing the following steps:
In order to use this content pack on PowerBI.com, after connecting to the portal you've to click on the Get Data button on the left pane:
And then in the Services box, select the Get button:
Now select the Microsoft Dynamics NAV content pack and click Get:
After the content pack selection, Power BI prompts you to enter the NAV OData URL. The URL has this schema:
https//navservername:port/NAV_Instance/OData/ Company('CRONUS%20International%20Ltd.')
Where
navservername
is the...