cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBITestingG
Helper II
Helper II

Triggering full refresh for dataflow and dataset

Hello,

 

I am using incremental refresh for my dataflow but I need to ocasionally trigger a full refresh to catch some stuff

 

My datasets are also using incremental refresh, how can I also trigger a full refresh for them? Any ideas?

 

3 REPLIES 3
otravers
Resident Rockstar
Resident Rockstar

If you republish from Power BI Desktop this will overwrite the existing partitions in the service.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog
shraddhabhagwat
New Member

Hi @PowerBITestingG,

 

You can use XMLA endpoints and perform full refresh of dataset manually.

This might be helpful : https://www.youtube.com/watch?v=5AWt6ijJG94

 

Thanks!

collinq
Super User
Super User

Hi @PowerBITestingG ,

 

I believe that the only way this will work is if you manually go in, turn off incremental refresh, then manually run a full refresh.  Then, after that manually run full refresh happens, turn back on incremental refresh.  There is not a "use incremental this time and not this time" option.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors