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
maruthisp's avatar
maruthisp
Icon for Super User rankSuper User
2 days ago

Hi powerlight1​,

The Include in report refresh option should prevent a table from being refreshed during a normal semantic model refresh. However, if the query is referenced by other queries, Power Query may still execute it to refresh those dependent tables.
Please try the following steps:

  1. Open Power BI Desktop → Transform data.
  2. Right-click the table you want to exclude and uncheck Include in report refresh.
  3. Go to View → Query Dependencies and check whether other queries reference this table.
  4. If other queries depend on it, Power Query may still evaluate the source query during their refresh.
  5. Select Close & Apply, save the PBIX file, and republish it to Power BI Service if required.

Important: Disabling Enable load is different from disabling Include in report refresh. Also, refreshing the Power Query preview can still execute the query independently.

My recommendation: If you want to keep the table's existing data unchanged, ensure that it is an Import table, disable Include in report refresh, and check that no other refreshing queries depend on it.

If the table is independent and still reloads during a normal refresh, I would suggest checking the refresh operation and Power BI Desktop version to narrow down the issue.

Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X            -  Maruthi Siva Prasad - (@MaruthiSP) / X