Skip to main content

Power BI

Needs Votes

Exclude a table from refresh in Power BI Service

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

6bb9126d ec1e-4a03-87ba-624527d540e3 on 05 Jul 2020 23:52:58

RE: Exclude a table from refresh in Power BI Service

Has this issue been fixed yet??

Jean-Pierre Riehl's profile image Profile Picture

d831adb9 cfe2-4fe0-8e35-fa987ca273e0 on 05 Jul 2020 23:52:29

RE: Exclude a table from refresh in Power BI Service

Most of the reports have static data, Need this option so badly.

Jean-Pierre Riehl's profile image Profile Picture

99c595dc 2946-4c56-a13b-71dcf5d54b8e on 05 Jul 2020 23:47:56

RE: Exclude a table from refresh in Power BI Service

Please make the PowerBI Service respect the option "Include in report refresh".
Right now when I add a static data source (eg. zip-codes) which I don't want to refresh through the gateway, I can't use the gateway at all because he can't find the file with the zip-codes.

Jean-Pierre Riehl's profile image Profile Picture

9549d817 6910-4aec-bb61-9321c48d0266 on 05 Jul 2020 23:47:25

RE: Exclude a table from refresh in Power BI Service

Is this by design so that Premium licensing is required to do incremental refreshes? I sure hope not.

Jean-Pierre Riehl's profile image Profile Picture

b49bb76d a075-402c-a9af-f27728c7266e on 05 Jul 2020 23:45:43

RE: Exclude a table from refresh in Power BI Service

please make this happen!!!!!

Jean-Pierre Riehl's profile image Profile Picture

b285212c 7156-4c00-8672-6d5390799f4b on 05 Jul 2020 23:44:17

RE: Exclude a table from refresh in Power BI Service

Adding to the comments that this needs to be added.

Jean-Pierre Riehl's profile image Profile Picture

d3464fd7 f0ce-483f-bc6e-639acd2a8b17 on 05 Jul 2020 23:43:16

RE: Exclude a table from refresh in Power BI Service

It’s a pain getting IT input a password into a shared sql database every time minor changes are made in an xl

Jean-Pierre Riehl's profile image Profile Picture

0021e8b9 b73c-4e8e-b299-125fa8b27d9b on 05 Jul 2020 23:42:25

RE: Exclude a table from refresh in Power BI Service

Agree with all the rest of the comments, this feature needs to be added into PowerBI Service.

Jean-Pierre Riehl's profile image Profile Picture

1a5762a7 899a-40c5-b957-cba37502f9ce on 05 Jul 2020 23:41:25

RE: Exclude a table from refresh in Power BI Service

This feature needs to added into PowerBI Service. Majority of the reports have static data.

Jean-Pierre Riehl's profile image Profile Picture

05a7fa06 a70c-488d-83f2-9dcaeb5fbb24 on 05 Jul 2020 23:41:19

RE: Exclude a table from refresh in Power BI Service

Need this desperately, have loads of reports where 80% of the data is static and historical, which I've partitioned in datasets with no refresh required. But to no avail with the BI Service. Making me consider other solutions.