Refresh delay optimisation tips anyone ?

[Anonymous]

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 🙂

[Janel]

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

[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

[GilbertQ]

Hi there, are you using a Scheduled refresh, or letting the Power BI Service control the refresh?

[Anonymous]

I'm using a scheduled refresh.

For example, my morning refresh is launched at 8:00 AM but my refreshed report is never ready before 8:25 😞

[v-ljerr-msft · Accepted solution]

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. 

Regards

[Anonymous]

Thank you for your help 🙂

[GilbertQ]

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/