Forum Discussion

Tonizh's avatar
Tonizh
New Member
1 year ago
Solved

How to open old pbix with error query ?

Hi guys,

 

I have an old PBIX which data source is SQL Server, we're using Direct Query in the report. "unfortunately" the database BAK file looks corrupted, but I have another BAK which succesfully restored but another unfortunate is this BAK file is older, so the DB is older with some missing fields which we added after this DB was backup. When connecting and query run, hit error some field is not exist.

 

May I know how to overcome / skip this error. I understand the error is because the column is not there, because it is older BAK file, but can I still open the PBIX and later I can remove some query or even measure that using the "missing" column (field) ?

 

Can share any idea ? appreciated.

 

Thanks

 

 

Tips and Tricks
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi Tonizh - In your situation, where the SQL Server database's structure has changed and some columns are missing from the restored older version, Power BI is unable to load the model due to the mismatch between the PBIX file and the current database structure.

     

    Edit Queries Without Loading Data:

    • Open the PBIX file in Power BI Desktop.
    • If the report doesn't load due to missing fields, try disabling query refresh:
      • Open Power BI.
      • Go to File > Options and Settings > Options.
      • Under Current File > Data Load, uncheck Enable background data.
    • This prevents Power BI from executing queries while you modify them.

    • Edit Queries in Power Query:

      • Open the Transform Data (Power Query Editor).
      • Identify the steps or queries referring to the missing fields.
      • Delete or modify these steps to stop referencing the missing fields.

    • Save and Reload:

      • Once the queries have been modified to match the database structure, save the file and reload the model.

    Follow the above steps , it works. 

     

1 Reply

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    1 year ago

    Hi Tonizh - In your situation, where the SQL Server database's structure has changed and some columns are missing from the restored older version, Power BI is unable to load the model due to the mismatch between the PBIX file and the current database structure.

     

    Edit Queries Without Loading Data:

    • Open the PBIX file in Power BI Desktop.
    • If the report doesn't load due to missing fields, try disabling query refresh:
      • Open Power BI.
      • Go to File > Options and Settings > Options.
      • Under Current File > Data Load, uncheck Enable background data.
    • This prevents Power BI from executing queries while you modify them.

    • Edit Queries in Power Query:

      • Open the Transform Data (Power Query Editor).
      • Identify the steps or queries referring to the missing fields.
      • Delete or modify these steps to stop referencing the missing fields.

    • Save and Reload:

      • Once the queries have been modified to match the database structure, save the file and reload the model.

    Follow the above steps , it works.