Forum Discussion
Power Query x Excel - Reading source 7 ~ 8 times
Hey guys, I'm making a new report and I stumbled into a situation that never happened before. It looks like PQ is loading my excel file about 8 times, taking about 6 minutes: only for these...
Hi,
Use Table.Buffer: The Table.Buffer function can help by buffering the table in memory, reducing the number of times the data is read from the source
Table.Buffer - PowerQuery M | Microsoft Learn
Solved: Power Query taking forever to load or refresh - Microsoft Fabric Community
I don't think Table.Buffer helps in this situation... just to make sure I tried on every step and still got the same results.