I have a Power BI Desktop data model but need to automate its refreshes in Power BI Service

[Lyubo_Hristov]

Hi all,

I have a ready-to-use Power BI Desktop file which uses SQL Database queries and has some heavy data transformations afterwards. This SQL database is stored in our office (on-premise). Later I published this file to the Power BI Service.

I need to set these Queries to Update from the database regularly in the background, so that this Power BI Reports are available online with up-to-date data when users open it in Power BI Service.
How can I automate this refresh? Does anyone have any specific suggestions on how to resolve this?

[v-yifanw-msft]

Hi @Lyubo_Hristov ,
Yes, make sure the gateway is online and the report will refresh automatically, even if you have not opened and updated the file yet. Viewers will see the latest available data and the dashboard will be refreshed.

Best Regards,

Ada Wang

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

[Hariharan_R]

Hi,

if you want to automate this then you need a gateway and data source. If you map your semantic model (dataset) against a gateway data source then your report dataset will automate update based on your schedule refresh.

Thanks

Hari

[Lyubo_Hristov]

And one more thing - would this be a substitute to the Dataflow solution (as I've seen this on some trainings on Udemy)? Or dataflows are used for other cases?

[Lyubo_Hristov]

Would the end-users (viewers) of the report see the latest available data (hence - the Dashboard(s) will be refreshed) even if I (the admin of the workspace) - haven't opened and updated the file?

Thanks