Forum Discussion
Loading XML to Power BI
Hello,
I would like to ask is possible to somehow optimize, make more effective process of XML file loading to power bi. Because it takes so long, file size is 2 MB.
Evaluating takes so much time.
3 Replies
Hi Analitika ,
Can you please share some more detail information about these getting data and operations in detail query steps? They should help us clarify your scenario and test.
How to Get Your Question Answered Quickly
In addition, you can also look at the following link about query table optimization if helps:
Best practices when working with Power Query - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng
File is uploaded here: https://filetransfer.io/data-package/HsjXIQFK#link.
Actually I am making get data, then select XML file, then select tables which to upload. Thene press load.
Hi,
I would like to ask how to quicker import XML in Power BI. I have 2 MB size XML and it's loading to Power BI takes about one day. So it is so weird. Here is a link to a file: https://filetransfer.io/data-package/HsjXIQFK#link . Any suggestions? Actually I made some modifications in Power BI file like data load table at once, no parralel loading.
Here is a picture how looks loading:
