I am trying to get my Odata feed to connect PowerBi. Looking into it I was told to go into Web Services, but when I go in there it does not exist. I have tried building it but it keeps returning an error which makes me think I have the wrong URL. How can I find this?
*This post is locked for comments
worked out well
I am in! My next question is I have only been able to get in to a single table at a time. Is there a way to give Power BI access to the entire database instead of creating an individual query for each table?
Ok I figured out part of the issue. I kept trying to do this through the desktop app, now that I am going through the website I actually see the Microsoft Dynamics Nav that everyone was talking about. I have my proper Nav Odata Url BUT I am struggling signing in. There are 3 authentication methods. I have tried each one and it just spins. Does the data take awhile? Or is it not working? If I was getting any sort of error I could work with that but it is still spinning so it isn't frozen.
for setting up power bi for connection with dynamics nav please follow
https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-microsoft-dynamics-nav/
https://ksdconsultancy.blog/2015/10/14/powerbi-com-content-package-for-microsoft-dynamics-nav-2016/
the user for connection needs admin rights, you have to use ssl.
for setup dynamics nav with ssl follow e.g. https://ksdconsultancy.blog/2015/11/04/configuring-ssl-to-secure-the-connection-to-microsoft-dynamics-nav-web-client/
administration tool: goto windows startmenu, search for the dynamics nav icons, one of them is the dynamics nav administration (a management tool for the nav services)
I went ahead and created it like in the link. When I try to connect to that Odata feed it says the User was not authorized. How is that possible when I created it?
I went ahead and created it like you said. When I try to connect to that Odata feed it says the User was not authorized. How is that possible when I created it?
Where is Nav Service Administration? When I look under web services I see two. The first is some sort of api that isn't published and the second is an integration for Magento that uses a soap api.
In the below URL you have the syntax and the examples how the url should look like, make sure the OData Services is enabled on NAV Administration tool as Archer mentioned
Please check the format of the URL. The OData URL created automatically when you are publishing a Page or Query object as web service. Then verify the availability of that web service you created.
Please go through this link for more clarity ;
check in nav service administration tool if soap and odata services are activated. if not activate them, then restart the nav service.
after that run page "web services", check if the published flag is set. if not set it, refresh the page. then the soap and odata links should be generated. click these links to show them in the IE. if the result is a kind of xml structure without errors, then all is ok.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
