Connect PowerBi to Nav 2013

(0) Share

Report

Posted on by Kamanicm

Hi,

I cant seem to connect my NAV 2013 to PowerBi.

The Powerbi team on twitter have confirmed that it is possible but have directed me to post here to get some help. i believe there's something wrong with the Odata link i keep trying.

Even tried the odata link in excel and still nothing.

Help will be greatly appreciated

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Suresh Kulla 50,237 Super User 2025 Season 2 on at

Like (0)

Report

RE: Connect PowerBi to Nav 2013

Hello,

Please let us know the steps you have followed to connect BI and the error you are getting when connecting?

Check this blog

https://blogs.msdn.microsoft.com/suvidha/2016/02/21/connecting-dynamics-nav-20132015-to-the-nav-content-pack-in-powerbi-com/

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

RE: Connect PowerBi to Nav 2013

The easy way is to publish your NAV Page you want as web service. NAV then gives you an OData url. From Power Bi you can open this OData url directly and read the data from NAV.

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

RE: Connect PowerBi to Nav 2013

There are few ways of connecting Power BI to NAV. One option is to connect directly to SQL database (in this option, you would just operate with SQL data without referring to NAV as such). Another (best) option, as Stefano wrote, is to create a web service (How to publish a web service: docs.microsoft.com/.../dd338978(v=nav.90) ). OData is a default easy connection type for PowerBI - just copy a link from you OData web service and paste it to PowerBI connection string.

Was this reply helpful? Yes No