Forum Discussion
iBusinessBI
4 years agoKudo Collector
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...
iBusinessBI
4 years agoKudo Collector
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_Deckler4 years agoCommunity Champion
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.