Skip to main content
Microsoft Idea

Power BI

Needs Votes

Extend "Include In Report Refresh" Further

Vote (200) Share
Matt Allington's profile image

Matt Allington on 07 Aug 2016 05:29:28

The new "Include in Report Refresh" released in July 2016 is a great addition - now the data modeller can selectively turn on/off tables to be refreshed.

It would be great to allow the user to set parameters and events to control when a table is refreshed. Eg a parameter that says "if a server cannot be found, then skip the refresh for a certain table". Maybe also allow users to set other events (or error codes) where selective processing can be managed. This will allow granular management of refreshing when a user needs to partially refresh a workbook as described here http://exceleratorbi.com.au/?p=17985

Comments (19)
Matt Allington's profile image Profile Picture

Wout O on 05 Jul 2020 23:47:56

RE: Extend "Include In Report Refresh" Further

Please also 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.

Matt Allington's profile image Profile Picture

Jan Power BI User on 05 Jul 2020 23:31:39

RE: Extend "Include In Report Refresh" Further

should be a gift and lot's of time gain.

Matt Allington's profile image Profile Picture

Andrey Minakov on 05 Jul 2020 23:31:07

RE: Extend "Include In Report Refresh" Further

It's very strange not to have ability to just append data to uploaded before. I think this should be in the product from the very beginning.

Matt Allington's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:08

RE: Extend "Include In Report Refresh" Further

Please address this!

Matt Allington's profile image Profile Picture

Anurodh on 05 Jul 2020 22:54:47

RE: Extend "Include In Report Refresh" Further

The power bi schedule refresh should be customized and allow refresh of specific data tables also. Some tables data is static and do not need any refreshing but the schedule refresh refreshes entire dataset. please solve this to make this functionality better

Matt Allington's profile image Profile Picture

Nick Raphael on 05 Jul 2020 22:32:07

RE: Extend "Include In Report Refresh" Further

I have a table of 50 million rows that never changes. I have a table of 1 thousand rows that needs hourly refreshing. Unless I can exclude the 50mill table from hourly refreshing, then I'm pretty much boned.

Matt Allington's profile image Profile Picture

Ivan on 05 Jul 2020 22:28:22

RE: Extend "Include In Report Refresh" Further

Good idea! Very useful in some cases.

Matt Allington's profile image Profile Picture

Imke Feldmann on 05 Jul 2020 22:27:13

RE: Extend "Include In Report Refresh" Further

Super idea to pass the trigger into the hands of the users!

Matt Allington's profile image Profile Picture

Thomas on 05 Jul 2020 22:27:12

RE: Extend "Include In Report Refresh" Further

Error and event handling for this feature will elevate it to a benefit!