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 ...
I'm relatively new to PowerBI and powerQuery, and maybe you have had this problem sorted out allready, but it seems like you have drawn data from an url without formatting it as xml data. I guess you have use a formula like:
Source = Web.Contents(https://some.url.here)
Which by default will return a HTML file. Try to wrap the web-connector in an XML formula like this:
Source = Xml.Tables(Web.Contents(https://some.url.here))
And I guess you will be fine