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.