Forum Discussion

ChenwuZhu_Gmail's avatar
ChenwuZhu_Gmail
Resolver I
6 months ago
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...
Need Help
  • FreemanZ's avatar
    FreemanZ
    6 months ago

    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:
    1. Close Power BI Desktop completely (ensure no background processes are running via Task Manager).
    2. Navigate to the auto-recovery folder (Windows):
      plaintext
      %LocalAppData%\Microsoft\Power BI Desktop\AutoRecovery
       
    3. Look for .pbix files with timestamps matching before you used Tabular Editor. Open the most recent one—your queries should be intact here.
FreemanZ's avatar
FreemanZ
Super User
6 months ago

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:
  1. Close Power BI Desktop completely (ensure no background processes are running via Task Manager).
  2. Navigate to the auto-recovery folder (Windows):
    plaintext
    %LocalAppData%\Microsoft\Power BI Desktop\AutoRecovery
     
  3. Look for .pbix files with timestamps matching before you used Tabular Editor. Open the most recent one—your queries should be intact here.