cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
valentin Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Refreshing report dataset and publishing to web with Powershell

Hi @valentin,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Refreshing report dataset and publishing to web with Powershell

Hi @valentin,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.