Publish without instant data refresh

[BIfanatic]

Hi everyone,

When publishing reports the service automatically starts refreshing the data. However, we just want to publish and do the data refresh at a later time. Our reports consist of SAP BW data and are being refreshed through an on-premise gateway.

We normally publish during office hours, but would like to do the refresh outside those hours so that our SAP users do not experience capacity issues. 

What are our options here?

[v-yuezhe-msft]

@BIfanatic,

After you publish the report to Power BI Service, go to Settings->Datasets and find your dataset, you can configure your dataset to refresh at specific time by setting the schedule .


Regards,
Lydia

[BIfanatic]

Hi @v-yuezhe-msft,

Thank you.

I am aware of the scheduled refresh option. However, when we publish a report, it instantly starts refreshing the data in the service. We do not want that. We want to split the moment of publishing and the moment of data refreshing.

Is that possible?

[v-yuezhe-msft]

@BIfanatic,

Dataset will not be automatically refreshed after you publish the report to Power BI Service unless you click "Refresh Now" or set schedule refresh. 

Have you checked the message in Refresh History?

Regards,
Lydia

[BIfanatic]

@v-yuezhe-msft

It seems that - when you have scheduled refresh turned on- after publishing the report starts refreshing immediately, even though the refresh might be scheduled for an other day.

[Anonymous · Accepted solution]

This is a problem i face as well, my solution is to turn off the schedule refresh, publish, turn the schedule back on.

Keep in mind if you do this, you will have whatever data is within the published file.  So as long as your publish has the current data, you are fine.  My usual practice has been to 'Download PBIX', make the change, turn of schedule refresh, publish, schedule back on.

[BIfanatic]

@Anonymous

This seems to be the best way. Thanks for confirming!