Forum Discussion
Excel Power BI AddIn shows wrong refresh date
Dear fellows
I encountered a strange behaviour in Excel when accessing Power BI models.
I start with "Get Data" -> "From Power Platform" -> "From Power BI".
Then I get a list of Power BI Datasets:
For example, these:
When I click on the "View dataset in Power BI" button, I get this information:
The date and time shown in Excel is the timestamp of the previous Refresh. Not of the last one.
Can anyone reproduce this?
Kind regards
Salvatore
- Verify directly in Power BI Service: Confirm the actual latest refresh time for the dataset in app.powerbi.com.
- Wait and Retry: After a refresh, wait 5-10 minutes before re-checking in Excel to allow for propagation.
- Update Software: Ensure both Power BI Desktop (if used to publish) and Excel are fully updated.
- Consider Temporary Glitch: It might be a transient issue; retry later.
If consistently reproducible even after waiting, it might be worth reporting to Microsoft Power BI support
4 Replies
- Verify directly in Power BI Service: Confirm the actual latest refresh time for the dataset in app.powerbi.com.
- Wait and Retry: After a refresh, wait 5-10 minutes before re-checking in Excel to allow for propagation.
- Update Software: Ensure both Power BI Desktop (if used to publish) and Excel are fully updated.
- Consider Temporary Glitch: It might be a transient issue; retry later.
If consistently reproducible even after waiting, it might be worth reporting to Microsoft Power BI support
This happened four hours after the last Refresh.
And it happened to me, and a client (he was the one who noticed this in the first place).
I need to check if this happens in another tenant.
Excel is not running on the client's infrastructure with the latest version (Version 2408 (Build 17928.20392) vs. 2504 (Build 18730.20186) on my Laptop.
An Update is not easily doable.Given the consistent reproduction and the environmental constraints, the most direct and impactful action is to report this behavior to Microsoft Power BI Support.
Well, while waiting for a potential fix, the workaround remains to always verify the true last refresh timestamp directly within the Power BI Service web interface (app.powerbi.com) as the authoritative source for dataset freshness.
I checked it within our tenant, and I can see the correct Refresh date and time within 3 minutes.
I will discuss the next steps with my client.
