Forum Discussion
Publish without instant data refresh
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?
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.
6 Replies
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,
LydiaHi Anonymous,
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?
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
