Forum Discussion

hkillen's avatar
hkillen
Icon for Helper I rankHelper I
4 years ago
Solved

Auto-Refresh select data tables / sources

Is it possible to program PowerBI to only AutoRefresh select data tables?  For example, if I have 10 data tables and I have PowerBI scheduled to auto-refresh at 0800.  At the time Power BI Auto-Refreshes, I only want PowerBI to refresh 4 select tables.  The other 6 tables, I will manually refresh when necessary.

Need Help

9 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    hkillen you can disable the refresh of the 6 tables in Power Query (right click on the relevant tables and you will see that toggle).
    The scheduled refresh will only refresh the 4 you want.
    For the other 6 you can do it manually through tools like Tabular Editor or SSMS but you need that dataset to resides in a Premium or PPU workspace as the xmla connection that is used for this mechanisem is a premium only feature


    In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.


    SpartaBI Logo

    Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

    Showcase Report – Contoso By SpartaBI

    • hkillen's avatar
      hkillen
      Icon for Helper I rankHelper I
      4 years ago

      OMG.  I think you're right.  Let me test it.  If you are right, I will bear you your children.  Will tell you how it works out.  THANK YOU!