Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Icon for Continued Contributor rankContinued Contributor
4 years ago

Microsoft NAVISION data connection

Hi everyone, just wondering how to connect Microsoft NAVISION in Power BI? Any links, video tutorials are highly appreciated 🙂
Need Help
Show and Tell
Tips and Tricks
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

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's avatar
    ronaldbalza2023
    Icon for Continued Contributor rankContinued Contributor
    4 years ago

    Unfortunately, we have no DBA to talk to 😄