Scheduled Refresh for Data Source and Dashboard from Desktop

[andi2333]

Hello,

I am still quite new to PowerBI and have built a corporate dashboard mainly based on excel sheets.

These sheets are updated on a daily basis, and right now, I always have to refresh the visuals in the PBI desktop app and then publish the reports to the web.

I would like to automate this, but I cannot find a way to do so...could anyone support?

Thanks

[v-zhouwen-msft · Accepted solution]

Hi @andi2333 ,

Regarding your question, you can set up a scheduled refresh for semantic models that have been published to Power BI Service. All you need to do is install the on-premises data gateway.For more details, you can refer to the following articles:

What is an on-premises data gateway? | Microsoft Learn

Install an on-premises data gateway | Microsoft Learn

Then manage the gateway and configure the data source credentials in Power BI Service.

Add or remove a gateway data source - Power BI | Microsoft Learn

Final Configuration Schedule Refresh.

Configure scheduled refresh - Power BI | Microsoft Learn