Forum Discussion

manoj_0911's avatar
manoj_0911
Icon for Kudo Commander rankKudo Commander
9 months ago
Solved

How to schedule both Full Refresh and Incremental Refresh in Power BI Service (similar to Tableau)?

  Hi Everyone, I need clarification on Incremental Refresh behavior in Power BI Service. In Tableau, I am able to schedule: Full Refresh once daily at 7 AM Incremental Refresh every 2 hours ...
  • Praful_Potphode's avatar
    9 months ago

    Hi manoj_0911 ,

     

    1. Is there a native way in Power BI Service to schedule both:

      • Full refresh (once per day)

      • Incremental refresh (multiple times per day)

    No we can not have both refreshes in the semantic model.When we configure incremental refresh in power bi desktop and publish it for the first time, then it will do full refresh as it has to create partitions based on refresh policy setup.post that every refresh that you do in power bi service is an incremental refresh.

    1. Does the Refresh now option always trigger a full refresh when incremental refresh is configured?

    No as i said in earlier Query , the first refresh is full refresh .post that every refresh is incremental refresh only.

    https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview 

    https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla 

     

    second article explains how partitions and refresh works.

    Please give kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    praful