Forum Discussion
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 ...
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.
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?