Skip to main content

Power BI

Needs Votes

Exclude a table from refresh in Power BI Service

Vote (901) Share
Jean-Pierre Riehl's profile image

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 (78)
Jean-Pierre Riehl's profile image Profile Picture

Laurenz H. on 10 Jun 2021 13:20:31

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

Jean-Pierre Riehl's profile image Profile Picture

Laurenz H. on 10 Jun 2021 13:19:42

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

Jean-Pierre Riehl's profile image Profile Picture

Laurenz H. on 10 Jun 2021 13:15:05

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.

Jean-Pierre Riehl's profile image Profile Picture

Laurenz H. on 10 Jun 2021 13:12:46

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

Jean-Pierre Riehl's profile image Profile Picture

Laurenz H. on 10 Jun 2021 12:42:13

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

Jean-Pierre Riehl's profile image Profile Picture

Joshua Flory on 07 May 2021 17:32:31

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 :(

Jean-Pierre Riehl's profile image Profile Picture

MELİK MASARİFOĞLU on 20 Jan 2021 13:18:39

RE: Exclude a table from refresh in Power BI Service

it has not been fixed yet please fix this

Jean-Pierre Riehl's profile image Profile Picture

Todd Chittenden on 04 Jan 2021 23:05:12

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.

Jean-Pierre Riehl's profile image Profile Picture

Todd Chittenden on 17 Dec 2020 21:49:28

RE: Exclude a table from refresh in Power BI Service

I, too, did a quick test just now and it looks like it might have been fixed. It it stable? A previous user indicates that the behavior varies.

So this just makes me wonder if and when Microsoft is going to get around to telling the rest of the world about this fix.

Jean-Pierre Riehl's profile image Profile Picture

Sami Assi on 17 Dec 2020 08:52:05

RE: Exclude a table from refresh in Power BI Service

Very important. Please add!

Merged Idea (2)