Incremental Refresh - Refresh past partition

[iBusinessBI]

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 needs to enter a Journal Entry for previous year - I need somehow to be able sometimes to refresh the last year also (without opening the Desktop).

It is only sometimes, "by demand". The rest of time it should only refresh the last 3 months.

Any solution to this?

[iBusinessBI]

@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]

@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.

[Greg_Deckler]

@iBusinessBI If you have Premium then yes. You can connect to the XMLA endpoint via SSMS and refresh a particular partition. Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...