Schedule reports in Excel to local path or network path

Schedule reports in Excel to local path or network path

Can I schedule a report to save the excel file instead of email it? I need Power BI to pickup the excel as a datasource and I'd like to update it daily.

Or, you know, provide the SQL query behind it so I can just grab the info from the database (server availability report).

Thanks!