Forum Discussion
Kudo CommanderHow 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
I am trying to achieve a similar setup in Power BI.
Currently, I can set only one Incremental Refresh schedule (example: every 2 hours).
But I don’t see any option to schedule a separate Full Refresh in addition to incremental refresh.
I also noticed that if I go to:
Workspace → Semantic model (Dataset) → … (More Options) → Refresh now
what it does full refresh or incremental?
My Questions:
Is there a native way in Power BI Service to schedule both:
Full refresh (once per day)
Incremental refresh (multiple times per day)
Does the Refresh now option always trigger a full refresh when incremental refresh is configured?
Environment Details:
Power BI Service
Incremental Refresh enabled
- Sql Server Data source - Contact Center Data
Scheduled refresh every 2 hours enabled
Thanks in advance for any guidance.
Hi manoj_0911 ,
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.
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
4 Replies
- lbendlin
Super User
What you are trying to do is meaningless as the smallest partition size for Incremental Refresh is DAY. So running a daily full refresh is counter productive.
Remember that you can use XMLA scripts to force refresh individual partitions.
- Praful_Potphode
Hi manoj_0911 ,
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.
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
Hi manoj_0911
I wanted to check if you had the opportunity to review the valuable information provided by lbendlin and Praful_Potphode . Please feel free to contact us if you have any further questions.
Thank you.Hi manoj_0911
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
