Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

data refresh in published report/dashboard



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 I mean the dataset and the report and the dashboard) be refreshed automatically when opening it online ?


And where in desktop and where in the online service can I see the latest refresh date of the report/dashboard/dataset ?


Thanks in advance



Microsoft Employee
Microsoft Employee

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.




Skilled Sharer
Skilled Sharer

According to the documentation here:


Excel file on OneDrive for Business refresh every hour, while dashboard tiles refresh every 15 minutes (but you can refresh on demand by clicking on the ellipse icon:




You can include a refresh date on tiles, like this:




You can set a refresh schedule for your Salesforce data (and other data sets). The frequency available will depend on your subscription type. Go here for each dataset:




In a report online, when you go into focus mode for a visualization, like this:




you will see the last-refresh date on the top right-hand corner:




Refresh dates are not available on PBI Desktop.

Connect with me in LinkedIn:
Follow me on Twitter:
Regular Visitor

extra question:


And what happens if I combine a desktop report on

- salesforce data

- local Excel that needs no refresh

- local txt that needs no refresh


and I publish it ?


Will the online report and dashboard (when opened at Power Bi Services) contain the latest data each time ?


kind regards



Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors