XML loading in Power BI takes many hours in Power BI

[Analitika]

Hi,

I would like to ask why XML file loading to Power BI takes so long, about 5-6 hours although file size is 2 Mb. How to resolve it?

[Anonymous]

Hi @Analitika 

Please consider whether the file is complex, if the file is too complex may affect the data loading speed, you can try to reduce unnecessary elements to optimize performance. you can refer to the following link.

Troubleshoot report performance in Power BI - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Analitika]

But  I need that all data.