Skip to main content
Microsoft Idea

Power BI

Needs Votes

Exclude a table from refresh in Power BI Service

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

Power BI User on 06 Jul 2020 00:11:47

RE: Exclude a table from refresh in Power BI Service

Please add this feature, we really need to only query the data that we need

Jean-Pierre Riehl's profile image Profile Picture

Power BI User on 06 Jul 2020 00:11:23

RE: Exclude a table from refresh in Power BI Service

Can't believe this bug is real

Jean-Pierre Riehl's profile image Profile Picture

Dominik on 06 Jul 2020 00:11:20

RE: Exclude a table from refresh in Power BI Service

As many others here said, this is very bad design. You basically disable refresh and it still wants to refresh the data source in Service. Just please fix it.

Jean-Pierre Riehl's profile image Profile Picture

Power BI Ideas Admin on 06 Jul 2020 00:11:11

RE: Exclude a table from refresh in Power BI Service

We need this! I am importing the same postcodes every time!

Jean-Pierre Riehl's profile image Profile Picture

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.

Jean-Pierre Riehl's profile image Profile Picture

Á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.

Jean-Pierre Riehl's profile image Profile Picture

Jagadeesh Kadimi on 06 Jul 2020 00:06:50

RE: Exclude a table from refresh in Power BI Service

Please Add this feature..ASAP

Jean-Pierre Riehl's profile image Profile Picture

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.

Jean-Pierre Riehl's profile image Profile Picture

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.

Jean-Pierre Riehl's profile image Profile Picture

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.

Merged Idea (2)