cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shebr
Resolver III
Resolver III

NAV Odata connection error with Gateway

Hi PBI community,

 

I am attempting to connect to NAV on premise with an Odata link. I have the oData URL and when connecting to it on the NAV server, I get as far the import of data starting, but then erroring based on the attached error. Can anyone advise of what is required to complete the import process?

 

https://1drv.ms/i/s!Ao9CJbxZBxvrjyozNlEX5luclayt

 

Nav Odata Error

 

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft
Microsoft

Hi @shebr,

Do you get the above error when connecting to Dynamics NAV content pack from Power BI by following the instructions in this article?

If that is the case, please check that if you have empty tables. As stated in the above article, empty tables will currently fail to import. Moreover, based on my research, someone gets the similar issue as yours when there was no data in one of the NAV web services, for more details, you can check Suvidha’s comment in this blog.

Thanks,

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuezhe-msft
Microsoft
Microsoft

Hi @shebr,

Do you get the above error when connecting to Dynamics NAV content pack from Power BI by following the instructions in this article?

If that is the case, please check that if you have empty tables. As stated in the above article, empty tables will currently fail to import. Moreover, based on my research, someone gets the similar issue as yours when there was no data in one of the NAV web services, for more details, you can check Suvidha’s comment in this blog.

Thanks,

Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors