Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am reading multiple folders and process some xml. files in the power query editor. After adding a 'column' to calculate something, it is now taking few hours to load the query and apply the new steps. It is weird that as shown below, it looks like it is reading a massive file with over 1 GB but my data source is not bigger than 200 MB. Any idea would be appreciated.
Please see this video and article. You are going to want to use Table.Buffer to avoid reloading your source data repeatedly.
(5) Inside Power Query reference queries for Power BI and Excel - YouTube
Power Query M Primer (Part 12): Tables—Table Think I | Ben Gribaudo
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks, it was helpful however did not solve my issue with slowness.
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |