Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
ronaldbalza2023
Continued Contributor
Continued Contributor

Microsoft NAVISION data connection

‎02-20-2022 04:25 PM

Hi everyone, just wondering how to connect Microsoft NAVISION in Power BI? Any links, video tutorials are highly appreciated 🙂

Message 1 of 4
1,146 Views
0
3 REPLIES 3
Fowmy
Super User
Super User

‎02-20-2022 10:14 PM

@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.


 

Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Message 3 of 4
1,072 Views
ronaldbalza2023
Continued Contributor
Continued Contributor
In response to Fowmy

‎02-21-2022 10:29 PM

Unfortunately, we have no DBA to talk to 😄

Message 4 of 4
1,057 Views
0
amitchandak
Super User
Super User

‎02-20-2022 06:30 PM

@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

https://www.fajdiga.info/blog/2018/05/09/connect-power-bi-with-dynamics-nav-through-dynamics-nav-con...

https://www.youtube.com/watch?v=-PcMdT5MxKQ

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Message 2 of 4
1,082 Views

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All