odata

[JavierEnroute]

I built a virtual database which publishes data using Odata protocol. I have been able to access the database using the url directly on  my browser as well as connecting using other tools such as Tableau, but the same URL throws an error on Power BI. This is the url i've used:

http://localhost:8080/odata4/EmpData/EmpData_Time/EmpData?$format=json

I have used odata v2-3 url as well, and though it does not throw an error, it does not bring all the records. I'm not sure why the same URL would work everywhere except with Power BI. 

[v-xjiin-msft]

Hi @JavierEnroute,

What kind of error did you get? Please share us the entire error message.

Thanks,
Xi Jin.

[JavierEnroute]

Xi Jin,

Attaching an image with the 2 errors. The parsing error appears when I format my data as json, and the second error when using atom as format. 

[v-xjiin-msft]

Hi @JavierEnroute,

Based on your first error message, it cannot parse the hostname of the URL. Since you are using the URL with Localhost:8080. Please verify that you can visit it on your machine first. Also make sure that the 8080 port was opened.

Then to troubleshoot the second error, please refer to following article:

Atom Format (OData Version 3.0)

Thanks,
Xi Jin.

[JavierEnroute]

I built a virtual database which publishes data using Odata protocol. I have been able to access the database using the url directly on  my browser as well as connecting using other tools such as Tableau, but the same URL throws an error on Power BI. This is the url i've used:

http://localhost:8080/odata4/EmpData/EmpData_Time/EmpData?$format=json

I have used odata v2-3 url as well, and though it does not throw an error, it does not bring all the records. I'm not sure why the same URL would work everywhere except with Power BI.