Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
miszel
Regular Visitor

Web Query URL with "?" (question mark)

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

1 REPLY 1
yan
Advocate I
Advocate I

Since the website requires a login, you are better off attaching the XML here for more responses - providing of course this is public data.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors