Forum Discussion
Refresh delay optimisation tips anyone ?
Hi guys,
I'm using a few Power BI reports using date files updated from Sharepoint & One Drive.
I've noticed that my report refresh delay on Power BI Desktop is about 2 minutes but is 20 or 25 minutes when loaded to the Power BI online service.
Do you have any tips to reduce this delay ? Thanks :)
Hi Anonymous,
Note:
When you configure a time for scheduled refresh, there can be a delay of up to one hour before it begins.
It is a known limitation for scheduled refresh currently. :smileyhappy:
Regards
7 Replies
- Hi there, are you using a Scheduled refresh, or letting the Power BI Service control the refresh?
Hi Anonymous
Hi there, as per the documentation from Microsoft whilst they try to get it as close as possible to the scheduled time, they do say that it can take quite a bit longer before the refresh occurs.
Here is the related details
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/
Related to this topic, I would like to know how to add the refresh date to a PBI Report that is placed on a SharePoint site. I have it on the Dashboard, but do not see how to add the refresh date to a Report. I have PBI Pro.
Thanks,
Janel
See my previous question here, but to show a refresh date for a report that is embedded on a SharePoint site you must create a query that goes and gets todays date and time, then put that field result on the report.
I got the answer here on this blog, but wanted to place it here in this thread, too.
The DAX formula is as follows that is placed in a query: = DateTime.Time(DateTime.LocalNow())&DateTime.Date(DateTime.LocalNow())
The table needs to be refreshed at the same time as the other report sources.
Janel
