Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
10 years ago

Get data from webservice

I am trying to bring data into my dashboard by accessing a websevice endpoint. It works fine in my mobile report wher i am using a dataset based on an xml data source. After proving URL of that data ...
Need Help
Youssef's avatar
Youssef
Microsoft Employee
10 years ago

You should be able to connect to Restful Web Services that return valid Json using the GetData from Web in Power BI Desktop.

 

From the screenshot, it seems that what returns from the URL you put is not Json but HTML. You can monitor the traffic with Fiddler and make sure what's coming back is actual json.

 

Hope this helps.

  • Markzolotoy's avatar
    Markzolotoy
    Impactful Individual
    10 years ago

    Do I need to change my data source after it's been created to say Json? By default it says HTML.

     

     

     

     

     

     

     

    But the reason I am not gettng json id because my webservice is not returning pure json?

    • Youssef's avatar
      Youssef
      Microsoft Employee
      10 years ago

      What is the data type you are expecting from your webservice end point? Is it Json? If so, they Power BI should perfectly support this scenario. Let me know if that's the case and you are still facing issues.

       

      If the data you are expecting is HTML data like a web page, you can refer to the articly linked in one of the replies above on more details on that. You might have to do some parsing and cleaning up in this case.

      • Markzolotoy's avatar
        Markzolotoy
        Impactful Individual
        10 years ago

        I am definetely expecting json. This is what I see in Chrome:

         

        {"root":[{"catchCount":127,"DisplayName":"Forward to Diagnostics Team","SeriesName":"Alarm Category"},{"catchCount":2685,"DisplayName":"Retrain Model","SeriesName":"Alarm Category"},{"catchCount":15,"DisplayName":"True Alarm","SeriesName":"Alarm Category"},{"catchCount":213,"DisplayName":"Contact Plant","SeriesName":"Alarm Classification"},{"catchCount":9,"DisplayName":"Contact Support","SeriesName":"Alarm Classification"},{"catchCount":2600,"DisplayName":"Monitor","SeriesName":"Alarm Classification"},{"catchCount":4,"DisplayName":"Schedule Maintenance","SeriesName":"Alarm Classification"},{"catchCount":204,"DisplayName":"Electrical Problem","SeriesName":"Alarm Clear"},{"catchCount":9,"DisplayName":"Historian Offline","SeriesName":"Alarm Clear"},{"catchCount":2609,"DisplayName":"Mechanical Problem","SeriesName":"Alarm Clear"},{"catchCount":2,"DisplayName":"Network Problem","SeriesName":"Alarm Clear"},{"catchCount":9,"DisplayName":"Stuck Valve","SeriesName":"Alarm Clear"}]}