Forum Discussion

powerlight1's avatar
powerlight1
Icon for Helper I rankHelper I
2 days ago

Disable "Include in report refresh" does not work

Hi I have an old report that has the data saved with the report, however the underlying table has changed so I want to keep the data that was saved in the old report and not refresh the data or the ...
power bi
Murtaza_Ghafoor's avatar
Murtaza_Ghafoor
Icon for Super User rankSuper User
2 hours ago

Hi powerlight1​ ,

The Include in report refresh option only disables automatic data refresh but It does not guarantee that your PBI report will preserve the old schema or ignore broken column references.

Step by step process to fullfill the requirements

  1. Take a backup of your existing PBIX file.
  2. Keep the existing table as a static snapshot.
  3. Disable its refresh.
  4. Check Power Query dependencies for references to removed or renamed columns( that is the most probable casue).
  5. Import the updated source as a separate table with a new name.
  6. Validate existing visuals, relationships and measures.

Important: If Power BI still evaluates the old query, export its existing data to CSV and use that as a static source.

If this helps, ✓ Mark as Kudos | Help Other