Forum Discussion

kora's avatar
kora
Regular Visitor
10 years ago

data refresh in published report/dashboard

Hello   I created a desktop report on a combination of Salesforce data, and a txt and xlsx file on OneDrive for Business.  Then I published it and pinned it to a dashboard.   Will the data (then...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
10 years ago

Hi Kora,

According to your description, you need to know the latest refresh date of the report, right?

 

If that is the case, you can add a query to get the latest refresh date.

 

  1. Click Get Date in PBI desktop and select Blank Query.
  2. Change the Name from Query1 to Last refresh date.
  3. Enter the code below on the formula bar.
    = DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())
  4. Click Close & Apply
  5. Create a new measure on this table
    Last refresh on = "Last refreshed on: " & FIRSTDATE('Last refresh date'[Last refresh date])
  6. Click on the card visual and insert the new measure Last refresh on.

 

Regards,