Forum Discussion
Post ProdigyImport XML in Power BI
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.
14 Replies
- PhilipTreacy
Super User
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.
- 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
- PhilipTreacy
- 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
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
Here's the sample XML file
https://drive.google.com/file/d/155TOSmvmojOE4bfL1K7vJVUroBs0HK5H/view?usp=drive_link
