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 (77)
- Merged Idea (2)
RE: Exclude a table from refresh in Power BI Service
Agree with everyone posting here. This "feature" doesn't make sense. I found the same behavior on the report server. If you uncheck the box to "Include in report refresh," that should still mean something once you've published the report in the Service or the Server.
RE: Exclude a table from refresh in Power BI Service
It happen so often, that You have beside database sources also local excel sheets as sources which contains static data. But if local PC is not online refresh on Power BI Services fail. I cannot understand that it is not possibe to exclude local data from beeing schedule refresh on Power BI Services. Please implement this feature as soon as possible. Thank You !
Michael Ressat
RE: Exclude a table from refresh in Power BI Service
Include is report refresh is a very useful feature. Please fix this design problem for PowerBI Service. We have a table with 157mil records and it does not require update for long period of time. However, due its size, all small table refreshes in the same data model have to suffer. IT IS IMPORTANT to have selective Table Refresh Feature. I am surprised how design team has missed it!
RE: Exclude a table from refresh in Power BI Service
I submitted this as a BUG through the standard Power BI channels based on the comment by someone at Microsoft who read this post and basically said that it's NOT an idea, but a BUG and should be submitted as such and tracked internally, etc.. After about three weeks the product team came back and called BY DESIGN. So that puts its focus back here on User Voice. I'm still doing battle with the Product Team to FIX it and will try to add additional comments to this thread as appropriate.
In the mean time, get your friends and relatives to sign up and VOTE!
RE: Exclude a table from refresh in Power BI Service
Please fix this!
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.
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".
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
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.
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 :)