Forum Discussion
When I connect to an XML URL, Power BI only returns document settings
Hi, I am working with ProjectorPSA data. I ran a report, and they provide a means of connecting to the results of that report via a URL. e.g. website.com/xmlconnectiondetails.xml. When I navigate...
sherryliu
Advocate I
Advocate ISame problem here. I have a field CompletionType.
XML:
Field Name: CompletionType Type: String Value: Online Completion
Power BI
Field Name: CompletionType Type: Any Value: Table
Inside the table
Field Name: Element:Text Value: Online Completion
Query related
#"Changed Type" = Table.TransformColumnTypes(Table4,{{"CompletionType", type any}})
in
#"Changed Type"
Can anyone help on this? The drill down and xml parser do not work out.
There's a way to do it called web scraping. But you have to know how the page is structured. This blog post really helped me a lot. Hope it will solve your issue. https://datachant.com/2017/03/30/web-scraping-power-bi-excel-power-query/