Refreshing report dataset and publishing to web with Powershell

Hello,

I am looking for a way to automatically refresh a datasource within a Power BI desktop report, and then publish it to web.

To give a bit of context, I have 10 reports, all identical but using different datasets. They are updated with new data once per week.

The datasets are all excel files, stored in a regular file system.

I already have a powershell script that archives the old dataset file, and replaces it with the new one. But I still need to manually open the report, click on "Refresh" and then on "Publish" and select the correct workspace, then replace the current report.

Since PowerBI is Microsoft, I thought there would be a way to do this with Powershell cmdlets, but so far I haven't found anything valuable.

Is it possible to do this with Powershell?

Thanks