Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 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
Kora
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.
Regards,
According to the documentation here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/
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.
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
Kora
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |