How to refresh Excel file on Sharepoint using sql query as datasource for use in Power BI

I have an Excel file stored on Sharepoint. I want to refresh that based on a sql query that was used to generate the Excel file. I have a power user that will connect to that file and then wants to create her own visuals and measures and joins etc. with that Excel file as the source. However, that file needs to have data refreshed daily. How can we automate this without wiping out any changes our power user has done to the reports she creates from the original file. 

I am using SSRS currently which will work  but can't export to Sharepoint and has to go to a folder first and then use Power Automate to move to Sharepoint.  I can set it to overwrite the file but seems like a lot of work and maybe just creating a datasource connection to sql query in Excel is a better option. Thank you.