Forum Discussion
Get data from webservice
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?
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.
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"}]}
Most likely this is received as HTML (although you are only seeing the JSON in the browser). If you right click in chrome, and click view source, you will see that this JSON snippet is likely encapsulated in HTML. If you can make sure your service sends pure json Power BI should resolve it as JSON with no problems.
Nope, page source shows exactly the same. So does Charles.