Can't load XML file in Power BI

[Analitika]

Hi,

I would like to ask how to import xml file to power bi. I tied importing but loading data in tables takes much time. How to resolve it?

XML file sizei s 2 MB, Are there solutions for it?

[v-binbinyu-msft]

Hi @Analitika ,

To import an XML file into Power BI, you can use the Power Query XML connector. Here are the steps to load a local XML file from Power Query Desktop:

Select the XML option in the Get Data selection.
Browse to the directory containing the local XML file you want to load, and then select Open.
If loading data in tables takes much time, you can try to optimize your query by filtering out unnecessary data or reducing the number of columns . You can also try to increase the performance of your query by using DirectQuery mode or by using a more powerful computer.

As for the size of your XML file (2 MB), it should not be too large for Power BI to handle. However, if you are still experiencing issues with loading data in tables, you can try to split your XML file into smaller files or use a different file format such as CSV .

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Analitika]

CSV not solves. It converts data in one line.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...