How to automatically Refresh and publish a report from PowerBI Desktop

[Anonymous]

Hello brains trust,

I have a Power BI Desktop Report that I can publish, but not refresh on Power BI Web.

Is there a way to automatically refresh and then publish are report to the web?
I would like to have a script that runs everyday that automatically does this for me.

Regards,

Rie

[Anonymous]

Hi @Anonymous ,

What is your data source? You may consider referring to the following blog to refresh the dynamic data source.
Setting a scheduled refresh on a Dynamic Data Source in Power BI

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query

Chris Webb's BI Blog: Handling Multiple URL Query Parameters With The Same Name Using Web.Contents In Power Query

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[amitchandak]

@Anonymous , Check if Power bi cmdlets can help

https://learn.microsoft.com/en-us/powershell/power-bi/overview?view=powerbi-ps

[Anonymous]

I have had a look but all the refresh I can see is related to Powershell Web and not Desktop.
Am I missing something?

[Anonymous]

Legend!
I will give it a go. Thank you.