How to set Query in the start like an XML file inside the URL as Query?

[toplisek]

I like PowerBI but have some issues. How to set Query in the start like an XML file inside the URL as Query?

[rajendraongole1 · Accepted solution]

Hi @toplisek  - You cannot pass a full XML or DAX/M Query string in the URL and have Power BI execute it., You can add query parameters to the report URL to filter visuals on load.

suppose, if you are store XML in a data source (Excel, SQL, Blob, SharePoint)Load and parse it in Power Query (Power BI supports parsing XML). Use the parsed data to control logic

reflinks:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

https://community.fabric.microsoft.com/t5/Desktop/URL-filtering-in-report-not-working/td-p/3173913

Hope this helps.

[v-ssriganesh]

Hi @toplisek,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @toplisek,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[rohit1991 · Accepted solution]

Hi @toplisek ,

Power BI, if you want to load data from a URL that returns XML (e.g., an API that serves XML responses), you can use the Web connector and then parse the XML using Power Query. Unfortunately, Power BI doesn't allow embedding XML data directly in the query URL as part of a payload in a traditional REST POST call — it primarily supports GET requests via the Web connector.

However, here's how you can load XML data from a URL at the start:

1. Open Power BI Desktop and go to Home > Get Data > Web.

2. In the URL field, paste the link to the XML file or endpoint (e.g., https://example.com/data.xml?param=value).

3. Click OK, and Power BI will load the XML data structure.

4. Power Query Editor will open where you can navigate the XML hierarchy, expand nodes, and transform the data as needed.

5. Once you're done shaping your data, click Close & Apply.

If your XML needs to be passed in the body of a POST request (instead of via URL), Power BI does support this using Advanced Options in the Web connector — there, you can switch the HTTP method to POST and paste the XML payload manually.

[v-ssriganesh]

Hi @toplisek,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @rajendraongole1 for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solution? If so, please mark it as the solution. This will help other community members solve similar problems faster.

Thank you.

[rajendraongole1 · Accepted solution]

Hi @toplisek  - You cannot pass a full XML or DAX/M Query string in the URL and have Power BI execute it., You can add query parameters to the report URL to filter visuals on load.

suppose, if you are store XML in a data source (Excel, SQL, Blob, SharePoint)Load and parse it in Power Query (Power BI supports parsing XML). Use the parsed data to control logic

reflinks:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

https://community.fabric.microsoft.com/t5/Desktop/URL-filtering-in-report-not-working/td-p/3173913

Hope this helps.