Forum Discussion
ronaldbalza2023
Continued Contributor
4 years agoMicrosoft NAVISION data connection
Hi everyone, just wondering how to connect Microsoft NAVISION in Power BI? Any links, video tutorials are highly appreciated 🙂
3 Replies
- amitchandak
Super 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
- Fowmy
Super 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.
- ronaldbalza2023
Continued Contributor
Unfortunately, we have no DBA to talk to 😄