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)

Andrew Telfer on 06 Jul 2020 00:08:56

RE: Exclude a table from refresh in Power BI Service

Hi everyone, found a "workaround" for this issue; watch this video on youtube, explains how to convert your file into a new query
https://www.youtube.com/watch?v=xuBfK0oJmw8

NOTE: if you have lots of data (i.e. rows & columns) this may not work, but it solved an issue i had with a file including over 85k rows.

Ágúst S. Eriksson on 06 Jul 2020 00:07:12

RE: Exclude a table from refresh in Power BI Service

Excluding this options seems a bit out of touch with the reality of the work done by analysts. Surprising for this otherwise brilliant product which the Power Bi is.

Jagadeesh Kadimi on 06 Jul 2020 00:06:50

RE: Exclude a table from refresh in Power BI Service

Please Add this feature..ASAP

Heath Heath on 06 Jul 2020 00:06:41

RE: Exclude a table from refresh in Power BI Service

I would really want to know why this wasn't fixed yet.

Johannes Siemer on 06 Jul 2020 00:06:38

RE: Exclude a table from refresh in Power BI Service

This is clearly a bug! Should be fixed as soon as possible.

Tracy Alers on 06 Jul 2020 00:05:28

RE: Exclude a table from refresh in Power BI Service

I thought that I had found a way to prevent refresh failures, but then I learned this... Not only is this counter to my goals of disabling "include in report refresh", but it's poorly communicated as well.

Power BI User on 06 Jul 2020 00:05:18

RE: Exclude a table from refresh in Power BI Service

please!! we need this feature =(

Todd Chittenden on 06 Jul 2020 00:04:50

RE: Exclude a table from refresh in Power BI Service

Was pointed here from this forum thread: https://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-report-refresh-quot-not-working/m-p/433165#M199673

I, for one, am absolutely APALLED that Microsoft would specify this as the 'default behavior'! It is the one huge oversight of the Power BI specifications.

Seriously, how can you specify TWO DIFFERENT behaviors for your product!

Let's get the word out to your fellow Power BI developers.

Michael Bristol on 06 Jul 2020 00:04:09

RE: Exclude a table from refresh in Power BI Service

Please Add this as it is important.

Dilkush on 06 Jul 2020 00:03:40

RE: Exclude a table from refresh in Power BI Service

Any update on this?

Merged Idea (2)