Exclude a table from refresh in Power BI Service
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.

25 comments
-
Michael Bristol commented
Please Add this as it is important.
-
Dilkush commented
Any update on this?
-
Teresa commented
Is there any update on this matter?
-
Johan commented
This is a must have feature for the service, especially for services like Google Analytics which have a limit before they reduce the accuracy of the queried results. How has this not been fixed yet?!
-
Martin Simms commented
Has this issue been fixed yet??
-
Mugundhan GT commented
Most of the reports have static data, Need this option so badly.
-
Anonymous commented
Please make the PowerBI Service respect the option "Include in report refresh".
Right now when I add a static data source (eg. zip-codes) which I don't want to refresh through the gateway, I can't use the gateway at all because he can't find the file with the zip-codes. -
Toby commented
Is this by design so that Premium licensing is required to do incremental refreshes? I sure hope not.
-
Jonelle Fidelino commented
please make this happen!!!!!
-
Anonymous commented
Adding to the comments that this needs to be added.
-
Anonymous commented
It’s a pain getting IT input a password into a shared sql database every time minor changes are made in an xl
-
jennifer staab commented
Agree with all the rest of the comments, this feature needs to be added into PowerBI Service.
-
naomi keetham commented
This feature needs to added into PowerBI Service. Majority of the reports have static data.
-
John Meyer commented
Need this desperately, have loads of reports where 80% of the data is static and historical, which I've partitioned in datasets with no refresh required. But to no avail with the BI Service. Making me consider other solutions.
-
Louis dorn commented
This definitely seems like a bug.
-
Anonymous commented
Is very important!
-
David Cresp commented
I have just realised that this is the issue that is meaning that I can't refresh in Power BI Service. It took me a while to find this idea and it seems crazy that you can turn refresh of in PBI Desktop but that this has no effect in Power BI Service. There are lots of cases that not all the data needs to be refreshed. Please MS make it so that this works in Desktop and PBI Sericve. It does not make any sence for this setting to not work in both locations.
-
NICOLE FALK SMITH commented
I too need to be able to exclude certain, static, tables from the refreshing.
-
Anonymous commented
We need the ability to have individual tables removed from any refresh process in the Power BI Service. There are situations where there are large, static tables (2.5+ million rows) that don't need to be refreshed by the service. If and when there is any need to refresh such, we could refresh in the Power BI Desktop and publish the dataset.
-
Mauro Medeiros commented
This is a serious problem. We have to manage a lot of connections that are not used in online refresh.