Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm accessing some XML data via Web Query, and I have a problem with the question mark in my URL.
The following expression works pretty fine:
let
Source = Xml.Tables(Web.Contents("https://play.dhis2.org/2.28/api/categoryOptionCombos.xml"))
in
Source
However this one:
let
Source = Xml.Tables(Web.Contents("https://play.dhis2.org/2.28/api/categoryOptionCombos?pageSize=225.xml"))
in
Source
is returning the error:
DataFormat.Error: Xml processing failed. Either the input is invalid or it isn't supported. (Internal error: Data at the root level is invalid. Line 1, position 1.)
Details:
Binary
Both URLs are valid and they work outside Power BI.
Any ideas how can I have my problem solved?
Best regards,
Miszel
Since the website requires a login, you are better off attaching the XML here for more responses - providing of course this is public data.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |