How do I get my Odata Feed?

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

keoma 32,729 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

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 ;

msdn.microsoft.com/.../hh165316(v=nav.90).aspx

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

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

msdn.microsoft.com/.../dd338978(v=nav.90).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

worked out well

Was this reply helpful? Yes No