Power BI

Needs Votes

Exclude a table from refresh in Power BI Service

Vote (903)

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)

Phil Curtis on 06 Jul 2020 00:12:51

RE: Exclude a table from refresh in Power BI Service

Big oversight, needs to be fixed on PowerBI.com Portal to match the Desktop option! Have raised a case (likely not the only one) and they've acknowledged, but it's not on their ETA timeline yet, so keep voting.

PowerBI.com customers should be able to have static tables with refresh disabled to avoid setting up unnecessary Gateway datasources to their PC which will eventually FAIL when PC or server switched off! Pasting into "Enter Data" tables is not always a solution as they only allow 3,000 cells.

Its perhaps good to encourage permanently refreshable Azure SQL DBs instead of static or semi-static tables, but better to fix this.

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

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

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.

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!

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.