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
Super User
Super User

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
Anonymous
Not applicable

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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors
Top Kudoed Authors