How can we improve Power BI?

← Power BI Ideas

Exclude a table from refresh in Power BI Service

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.

143 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    Jean-Pierre Riehl shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    12 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • David Cresp commented  ·   ·  Flag as inappropriate

        I have just realised that this is the issue that is meaning that I can't refresh in Power BI Service. It took me a while to find this idea and it seems crazy that you can turn refresh of in PBI Desktop but that this has no effect in Power BI Service. There are lots of cases that not all the data needs to be refreshed. Please MS make it so that this works in Desktop and PBI Sericve. It does not make any sence for this setting to not work in both locations.

      • Anonymous commented  ·   ·  Flag as inappropriate

        We need the ability to have individual tables removed from any refresh process in the Power BI Service. There are situations where there are large, static tables (2.5+ million rows) that don't need to be refreshed by the service. If and when there is any need to refresh such, we could refresh in the Power BI Desktop and publish the dataset.

      • Mauro Medeiros commented  ·   ·  Flag as inappropriate

        This is a serious problem. We have to manage a lot of connections that are not used in online refresh.

      • Michiel commented  ·   ·  Flag as inappropriate

        I agree with Eoin that this is a bug, or at least an 'undocumented feature'. IMHO, the 'include in report refresh' feature in Power BI Desktop doesn't make sense when it doesn't work in Power BI service.
        Please please please fix this!

      • James Houck commented  ·   ·  Flag as inappropriate

        Yes, the "Exclude from Refresh" should definitely persist to the service once the report is published from the desktop. In the interest of speeding up my data refreshes within the Power BI client, I have many dimension tables that remain static and I don't need to requery them. On second thought, having a scheduled for EACH table would be even better!!!

      • Vinney K commented  ·   ·  Flag as inappropriate

        For context, I arrived at this post through a thread originating from this post attempting to create a workaround for the lack of incremental load in datasources: http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
        This would have been an acceptable temporary workaround were it not for the issue of excluding from report refresh having no effect in the Power BI service.

      Power BI Ideas: Data Sources

      Feedback and Knowledge Base

      (thinking…)

      Ready to get started?

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