Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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