Forum Discussion

iBusinessBI's avatar
iBusinessBI
Icon for Kudo Collector rankKudo Collector
4 years ago

Incremental Refresh - Refresh past partition

I have configured Incremental Refresh so has the data of the last 20 Years and it refreshes only the last 3 months (it runs on SQL Server of an accounting system). In the case of Accounting Audit ne...
Need Help
iBusinessBI's avatar
iBusinessBI
Icon for Kudo Collector rankKudo Collector
4 years ago

Greg_Deckler 
Sorry for not clarifying:

The question is if there is an option to let my users refresh the whole dataset "by demand".

I do have access via SSMS to the partitions, but my users are accounting folks that only work with the service...

Is it possible for them to trigger this special refresh?

Thanks

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
4 years ago

iBusinessBI You *might* be able to get there using a Power Automate flow that you would tie to a Power Automate visual. The flow would trigger a refresh of all of the partititions. This is "in theory", you would have to confirm that it is possible.