Issue with Last Refresh Date/Time in Power BI

If we create a query inside Power query editor with DateTime.LocalNow() function to get Last refresh date/time, then there is a very big problem. This almost gives the refresh Start time, because this individual query is very smalls. And if your dataset takes much time to complete it’s refresh, then result of above query is not much useful. Til now we were looking at the TimeZone conversion, but this particular problem is mostly overlooked.
In this video We will try to solve this issue using some tricks.

This video will answer below query-
- How do I get the last refresh data in Power BI?
- How do I check my Power BI refresh history?
- How do I add refresh time in PBI?
- How to fix issue with last refresh time in power bi
- Power BI last refresh date on report


Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric

Follow us on LinkedIn
@PowerBIHelpline

[mirrrvelll]

Interesting approach, but look at this:

= #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()-#duration(0, -1, 0, 0)}})

Last part is actually the only part where you need to adjust according to your Location. And it has exact "timing" in Service.

We struggled a lot with this discrepancies but since I manage to solve it, it gives quite correct time.

[Nalaka-Wanniarachchi]

Good workaround.But if i use incremental enabled XMLA manual refresh for historical partition i might not be able to see the latest refresh as this is getting max refresh of the latest partition.Anyway for most cases your solution might suit.

[MichalS]

you can use pbi rest api to get correct refresh times

[wexwexexort]

I think the correct approach is to display the start time, not end time. So there is no issue.