Forum Discussion
ronaldbalza2023
4 years agoContinued Contributor
Microsoft NAVISION data connection
Hi everyone, just wondering how to connect Microsoft NAVISION in Power BI? Any links, video tutorials are highly appreciated 🙂
3 Replies
- amitchandakSuper User
ronaldbalza2023 , refer if these can help
https://docs.microsoft.com/en-us/dynamics-nav-app/across-how-use-financials-data-source-powerbi
https://docs.microsoft.com/en-us/dynamics-nav-app/across-powerbi
This one is no more beta- Available as connector
- FowmySuper User
ronaldbalza2023
I used to connect directly to the SQL DB that hosted the Navision data, you may ask your DB Admin to create VIEWS and access them for better performance and convenience.
The other approach is to connect using the Web Services with Odata connector, this allows you to access nav pages, Queries and Code Units.
- ronaldbalza2023Continued Contributor
Unfortunately, we have no DBA to talk to 😄