Pushing Published Report post schedule refresh as file to shared drive

Hello Experts,

I have one use case where we have a report (On Prem SQL Server as source) which is published on service and have schedule refresh now once the schedule refresh is done, we need to push the report as file (.pbix) to some shared location.

Appreciate if you provide your thoughts and input on this use case.

I have some idea using API or dataflows or Power Automate but not entirely sure or haven't done any use case like that so if you ever have done this or anything similar then it will help me understand better.

Thank you in advance for your time and support.. Be Safe !!!