NAV Odata connection error with Gateway

[shebr]

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

[v-yuezhe-msft · Accepted solution]

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