Forum Discussion

JavierEnroute's avatar
JavierEnroute
New Member
8 years ago

odata

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. 

4 Replies

  • JavierEnroute's avatar
    JavierEnroute
    New Member
    8 years ago

    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. 

    • JavierEnroute's avatar
      JavierEnroute
      New Member
      8 years ago

      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's avatar
        v-xjiin-msft
        Solution Sage
        8 years ago

        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.