Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |