Forum Discussion

misak's avatar
misak
New Member
9 years ago

ODATA error when fetching from Dynamics NAV

Hi,

 

I am trying to get data from NAV 2015 into Power BI.

 

In Denmark the equivalent of a "LTD" company is a "A/S" company.

 

That means that my ODATA URL is 

https//instance.navserver.com:7048/DynamicsNAV90_Instance1/OData/Company('Company A/S')

 

If I enter this URL in Power BI, I get a query error. If I replace the slash in A/S with a %2F I still get a query error in Power BI. But this URL with %2F works in a browser.

 

I then started wireshark and sniffed on the network. Power BI is replacing the "A%2FS" with "A/S" in the HTTP(S) request on the network. How do I prevent this?

 

My next step would be to configure a Apache proxy between Power BI and NAV to do a simple URL manipulation, but I would prefer a simpler solution.

 

/Morten

 

 

 

 

3 Replies