Import XML in Power BI

[Analitika]

Hello,

I would like to ask how I could quickly import xml file in Power BI. Because I waiting import so long. 2 MB file takes about several days to import and  that is terrible.

[PhilipTreacy]

Here's the sample XML file

https://drive.google.com/file/d/155TOSmvmojOE4bfL1K7vJVUroBs0HK5H/view?usp=drive_link

[PhilipTreacy]

Hi @Analitika 

Yes all 200+ tables.  At the point where it's Evaluating the queries click on Skip.  The data will load anyway and you should be ok.  It took a little while to load on mine but only a few seconds.

Regards

Phil

[Analitika]

I inserted 5 files. 6 file loading over 5 hours

[PhilipTreacy]

Hi @Analitika 

Thanks for the file.  I can import that to PBI without issue in a few seconds.

How exactly are you getting the file?  From a folder?  Server?  A website?

regards

Phil

[Analitika]

I downloaded file from website. Do you selected all tables from file?

[PhilipTreacy]

Hi @Analitika 

That URL is flagged as malicious by my antimalware software and by Virus Total.

Please upload your XML file to somewhere like OneDrive or Google Drive.

Regards

Phil

[Analitika]

Here is a link. https://drive.google.com/file/d/155TOSmvmojOE4bfL1K7vJVUroBs0HK5H/view?usp=drive_link

[PhilipTreacy]

Hi @Analitika 

Google Drive tells me I don't have access and have to request it.

Regards

Phil

[Analitika]

what is your email address?

[PhilipTreacy]

@Analitika 

You can send me a message through these forums.  Click on my name and then on the right, send Private Message.

Phil

[Analitika]

I need your email that I could share xml file with you.

[PhilipTreacy]

@Analitika 

Please use the forum messaging system.

Phil

[PhilipTreacy]

Hi @Analitika 

Well that clearly isn't right but withotu seeing your code and understanding what you are trying to do, it's hard to help.

Please provide your file/code and an explanation of what it is you are doing.

Regards

Phil

[Analitika]

Hi,

I just make like this. Get data, import xml to power bi that's all. Loading xml to power bi takes a lot of time although file size is 2 MB. Here is how the file looks like https://filetransfer.io/data-package/O1EhEcE9#link.