Refreshing report dataset and publishing to web with Powershell

[Anonymous]

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

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

I'm afraid we can't do it in the Desktop. Actually, there is an elegant way. You can publish the reports to the Service and set up schedule refresh with a data gateway. Finally the refresh job will be done automatically. Please refer to power-bi/refresh-data and refresh-scheduled-refresh.

Best Regards,

Dale