Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 2...
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

Janel's avatar
Janel
Frequent Visitor
8 years ago

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's avatar
    Janel
    Frequent Visitor
    8 years ago

    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