Forum Discussion
XML Madness!
I have a client who wants to load 12.4GB of deeply-nested, hierarchical XML messages directly into PowerBI on an ongoing basis without going via an ETL layer of any kind. Please could you validat...
That sounds like a potentially heavy load for Power Query. You could test it and see how it performs, but it's generally better to perform intensive tasks with an enterprise-grade ETL tool. Power Query is an excellent tool, but it may not perform as well as ETL tools in all cases. Check out Chris Webb's blog to see if he has any articles on the topic: