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 (80)
- Merged Idea (2)
RE: Exclude a table from refresh in Power BI Service
This would be very useful! Often there is a big table containing historical data that doesn't change over time. Now the refresh is slow because of this tables that don't need a refresh at all.
RE: Exclude a table from refresh in Power BI Service
This is very useful. When can we anticipate?
RE: Exclude a table from refresh in Power BI Service
Another Idea about this topic: https://ideas.powerbi.com/ideas/idea/?ideaid=dcf8d499-1bb5-43a5-b9e0-a0be2266d6da
RE: Exclude a table from refresh in Power BI Service
There is also a even older and bigger Idea about this topic: https://ideas.powerbi.com/ideas/idea/?ideaid=c464fb1a-25e4-4c93-ba72-288a6ff12127
RE: Exclude a table from refresh in Power BI Service
I also contacted support about it. -> was told that it's as designed and to create a Idea -> https://ideas.powerbi.com/ideas/idea/?ideaid=44f7ca13-e8c9-eb11-ba5e-281878bdaa58
I also started trying to collect votes. But since your Idea is already much bigger I will use this now.
RE: Exclude a table from refresh in Power BI Service
There is a much bigger Idea already heading in this direction: https://ideas.powerbi.com/ideas/idea/?ideaid=c464fb1a-25e4-4c93-ba72-288a6ff12127
RE: Exclude a table from refresh in Power BI Service
I just upvoted your Idea. I agree that it's a bug from user perspective. Unfortunately Microsoft seems to disagree.
Previously I also opened a ticket with Microsoft. But there I just got info about all the "workarounds" and that it's not a Bug.
I have also created my own Idea to increase pressure:
-> https://ideas.powerbi.com/ideas/idea/?ideaid=44f7ca13-e8c9-eb11-ba5e-281878bdaa58
RE: Exclude a table from refresh in Power BI Service
Is this REALLY fixed? I'm still having issues where I will remove a table from inclusion in refresh and it still throws an error :(
RE: Exclude a table from refresh in Power BI Service
it has not been fixed yet please fix this
RE: Exclude a table from refresh in Power BI Service
I just heard back from someone at Microsoft who offered some insight into this 'issue'. Apparently, it works now but requires a V3 model (July '20) or the "enhanced metadata format" preview feature.
If you want to get it working, I think you should be able to A) download and install the latest Power BI Desktop, B) open your model in the new Desktop, and C) re-publish to the service.