How can we improve Power BI?

Extend "Include In Report Refresh" Further

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

112 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Matt Allington shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

14 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

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

  • Sergey commented  ·   ·  Flag as inappropriate

    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.

  • Todd Chittenden commented  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

  • Andrey Minakov commented  ·   ·  Flag as inappropriate

    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.

  • Anurodh commented  ·   ·  Flag as inappropriate

    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

  • Nick Raphael commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.