Skip to main content
Microsoft Idea

Power BI

Needs Votes

Exclude a table from refresh in Power BI Service

Vote (869) Share
Jean-Pierre Riehl's profile image

Jean-Pierre Riehl on 2017-08-17 15:02:16

Ability to exclude a table from Data Refresh (scheduled, manual, API, etc.) in the Service.
In PBI Desktop, we have an option "Include in report refresh" we can disable for a table. But it won't affect PBI Service.

Comments (77) Merged Idea (2)
Vote 35
Laurenz H.'s profile image

Laurenz H. on 2021-06-10 12:33:37

Power BI

Power BI Service - Include in report refresh - disabled

In Power BI Desktop, in the Power Query Editor you can configure the setting "Include in report refresh" for each query. In Desktop this will then just contain the information from the fist time when this was accessed. And never try to reach for the source file to refresh it. If this report ist...

Vote 8
Michael Milirud's profile image

Michael Milirud on 2020-07-04 12:58:45

Power BI

"Include in report refresh" doesn't work when query is referenced

Unchecking "Include in report refresh" is supposed to stop refreshing the query, yet if you reference that query in another query (something you'd do if you wanted to hold a local cache of the static data *not* to be refreshed), it disregards the setting and refreshes it again. Clearly a bug. Ple...