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 (51)
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 :)
RE: Exclude a table from refresh in Power BI Service
Very misleading functionality as it currently exists and has led to many production issues.
RE: Exclude a table from refresh in Power BI Service
Hi, please add this feature!!
RE: Exclude a table from refresh in Power BI Service
Why is it that this issue has been reported since 2018 and still has not been resolved? Is there any intention to address it?
RE: Exclude a table from refresh in Power BI Service
It has taken me 3 days to figure out that this is what the problem has been for weeks with scheduled refreshes in the Power BI service that fail trying to refresh a table I've disabled load for. Why in the name of all that's holy would the service query a table that you've marked not to query? I agree with the comment that this is a bug, rather than an enhancement. I've needed to completely delete queries that I disabled in Desktop because they were failing in the service.
RE: Exclude a table from refresh in Power BI Service
Any update on this?
I have tables coming from both: Business Central (dynamic data that need to be refreshed 8 times a day) & Azure SQL database (fix data that needs to be refreshed only once a week)