Hi All.
I found in power query for excel, that if a source query runs sql to pull data (connection only), and that source is used by multiple other querys, the source runs each time it is needed... it appears that it the results are not loaded into memory. Just so happens that in PowerBI, it seems to only pull the source once - same querys run faster in powerbi vs excel. I also remember reading something about the difference of running in powerbi vs excel.
To speed up the querys, I load the source sql results to a sheet instead of connection only... then have the later queries pull the data from the loaded sheets. This make it run faster.
In the past, I have written custom vba code that refreshes the queries based on their names. I name the source queries that run and load to local sheets starting with "00)". Then I have my code refresh all "00)" queries first, then refresh all others.
So.... do I really need to do the refresh with the custom code or will PQ know and do it for me.
Thanks.
Steve
Harrisburg, PA USA
Bookmarks