Extend "Include In Report Refresh" Further

[matt16]

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

[sergey_fedotov]

It's a shame that so long after the original post this idea still has not come to fruition. There are some tables in our models that we only load from configuration files once, and don't need to touch at all - like the calendar table. Because we have MFA enabled, I cannot refresh from SharePoint online, and having my PC on all the time for gateway connection seems to be a poor workaround.

[fbcideas_migusr]

Very useful! Stop refreshing static data! Woohoo!

[fbcideas_migusr]

See this post on the forums: https://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-report-refresh-quot-not-working/m-p/517796#M242093 The feature to "Include (or not) in Report Refresh" is a waste of time. It is ONLY honored by Power BI Desktop and NOT honored by Power BI Service. So even if you DON'T want to have a data set refreshed by unchecking that box, Power BI SERVICE WILL try to refresh it. I see this as a BUG. Microsoft may tell us that is it "by design", to which I would respond that it is a horrible design specification that needs to be re-worked.

[ouma_ronald]

Great Feature to have, currently stuck with a problem, i have a budget file i uploaded that i do not wish to refresh

[gracezhu814]

A must-have feature!

[vatsal_makadia]

Allows granular control, must have feature

[Brett_Phillippe]

Is there a way to accomplish this using incremental refresh somehow? Since its not a "feature" it feels like there's a work around using incremental refresh to not look at that data for more info.

[Giedrius_Vegys]

Without this feature many opportunities to use Power BI with databases that do not use transaction tables are lost. For example Project management data bases. You can not do much of analytics on such databases as they are "spot databases" (i.e. they have meaningful information only on the date when they are refreshed).