Forum Discussion
Solved
Power Query Editor cannot be used
In Power BI Desktop, I used the external tool Tabular Editor to create partitions, and then my Power Query became inaccessible, and all queries have disappeared. It goes wrong when i click apply. The...
hi ChenwuZhu_Gmail ,
it was suggested like:
The "Collection was modified; enumeration operation may not execute" error on apply typically stems from conflicts between Tabular Editor’s schema changes and Power BI’s internal data model state. Below is a structured, step-by-step solution to recover your queries, fix the error, and prevent recurrence, tailored to your scenario:Step 1: Immediate Recovery (Retrieve Disappeared Power Query Queries)The queries are not permanently deleted—they’re hidden due to a schema mismatch between Tabular Editor and Power BI. Follow these steps to restore them first:Option A: Restore from Auto-Recovery (Fastest)
Power BI Desktop auto-saves recovery files. Here’s how to access them:- Close Power BI Desktop completely (ensure no background processes are running via Task Manager).
- Navigate to the auto-recovery folder (Windows):plaintext
%LocalAppData%\Microsoft\Power BI Desktop\AutoRecovery
- Look for .pbix files with timestamps matching before you used Tabular Editor. Open the most recent one—your queries should be intact here.
Hi ChenwuZhu_Gmail ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.
Thank you.