Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Incremental Refresh to load All data once again

Hi All, I want to refresh all the data from the database. When Increment Refresh enabled at the first time it will load all the data. But later it will load only incremental basis. Now I want to l...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Check below pictures. Turn off the Incremental Refresh then click 'refresh now'. After the refresh was complete, turn on the button again.

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dear Jay, Community Support! 

 

Just to be sure that I understand this solution right. So the suggested flow here is: 

  1. take the original file in power bi desktop, and switch off the incremental refresh at all the table
  2. publish the file back to the service
  3. refresh the data in the service (with the limited data based on the parameter values) 
  4. set up again the incremental refresh in the power bi desktop
  5. publish the file back to the service 
  6. hit the refresh for the new incremental load 

I am asking because I didn't find any option to do these in the service itself. 

If it is the case then I would rather say it is not an acceptable solution rather a pretty dirty workaround 🙂