Power BI

Needs Votes

Exclude a table from refresh in Power BI Service

Vote (879)

Jean-Pierre Riehl on 17 Aug 2017 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 (83)

Daniel Shapiro on 19 Sep 2020 22:35:02

RE: Exclude a table from refresh in Power BI Service

Please fix this!

Helene Seyr on 09 Sep 2020 12:32:56

RE: Exclude a table from refresh in Power BI Service

I agree with the comments before me, this is not a new feature, but rather a bug fix. Having the selection from PBI desktop not affect PBI service is counter-intuitive design.

bla Power BI User on 09 Sep 2020 08:01:38

RE: Exclude a table from refresh in Power BI Service

Fix this bug please. This is not a "feature". This should be standard behaviour when selecting "do not include in report refresh".

Jonathan Thomson on 03 Aug 2020 09:00:47

RE: Exclude a table from refresh in Power BI Service

This is needed. Like the OP I assumed that include in report refresh would be reflected in the service, but it isn't, so I cannot quickly fix a report that's temporarily broken and need to remove it so everything else works. This would have great benefits for several sets of archiving that I'm wanting to do, but cannot as it would require the tables to always be present

Todd Chittenden on 10 Jul 2020 17:22:02

RE: Exclude a table from refresh in Power BI Service

Going on 3 years now that this has been like this and yet NO RESPONSE FROM MICROSOFT. Oh, they may say, "It's by design" to which we would all answer, "Well, it's POOR design and you need to re-think it!"

Let's get the word out to friends and co-workers and anybody you might know at Microsoft to raise awareness of this issue.

Michael Milirud on 06 Jul 2020 00:18:27

RE: Exclude a table from refresh in Power BI Service

This feature was clearly never completed e2e (happens). And now you have enough votes to justify scheduling its completion (necessary for prioritization). Let's do it :)

Michael Milirud on 06 Jul 2020 00:18:26

RE: Exclude a table from refresh in Power BI Service

Looks like it was also raised here: https://community.powerbi.com/t5/Issues/Bug-in-quot-Don-t-include-in-Report-Refresh-quot/idc-p/112237#M1627 and resolved as By Design, but then how do you cache static result in PQ so you don't hit the source every single time? It's something I want to load once and then merge with other dynamically refreshing tables as needed.

A simple fix to this would be to have PQ convert result of a query marked not to be refreshed to a static table, similar to what we can do with Enter Data option: Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText(...