Forum Discussion

NerdyBen's avatar
NerdyBen
Copper Contributor
Dec 05, 2019

Excel files fail to open when PQ is used

Hi folks, I've not found any information on this error, but if it has been posted before let me know. I've run into some kind of bug when I try to open a locally saved Excel file in which Power ...
BI & Data Analysis
excel
office 365
crazyshoots's avatar
crazyshoots
Brass Contributor
Dec 09, 2019

NerdyBen Hi, was the power query running when you were opening the file?

If so, it's not a bug. Power Query will run into error if the base file is opened while running the codes (even background) so my best practice is not to keep the base files open until power query has ran and settled.

 

Otherwise, it might be a possibility that your query is huge (especially if it is loaded to a worksheet) and eats up the memory to open the other excel files.

NerdyBen's avatar
NerdyBen
Copper Contributor
Dec 10, 2019

crazyshoots Thnx for the reply. The power query was not running: it's window was closed. I know I can't even go back to excel while running PQ, because I have to close it first (close&load). Secondly, the query is not huge, about 10k-15k rows, 10 columns. It does load it to excel though, but it should be able to handle that. The file sizes are all under 10 mb and it happens with multiple different files with different queries.

 

Resources