Issue with Last Refresh Date/Time in Power BI

[@mirrrvelll5164]

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.

[@PowerBIHelpline]

Did you notice if it shows a time which is very near to refresh start time ? The whole idea about this video is not about Time Zone conversion, but it is about refresh end time. In a query like above which is an individual small query, will refresh very fast, and will return the time of its own refresh time, not the time of the entire dataset which may take several minutes.

[@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.

[@PowerBIHelpline]

Absolutely right! The most accurate way is to fetch the refresh history page from the service. and the only way there is to use API. Thanks for watching.

[@wexwexexort]

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

[@PowerBIHelpline]

Yes, you can use that where Refresh time is not much important. However, Power BI Service always shows Refresh end date/time in "Refreshed column " of the dataset or "Data Updated on" in report's detail section shows refresh end date/time, not the start time

[@wexwexexort]

@@PowerBIHelpline The service is wrong in my opinion. It should be the start time. Because the data included in the dataset ends at the start time.

[@PowerBIHelpline]

I understand what exactly you are trying to convey, You are actually talking about the data available in the actual data-source where Power Bi is connected with. and that will definitely pull whatever is available at its start time. but Power Bi has nothing to do with your actual data is refreshing or not in the data source system. even it doesn't update , next day power BI refresh start time will show new date time. so that is a different case all together where we apply other technique. like storing a timestamp as a column in the actual data source itself, and then show that value in the report.

[@MichalS73]

you can use pbi rest api to get correct refresh times

[@RichardOliver]

He mentioned that.

[@sandeepbarge4699]

How to handle day light savings time?

[@PowerBIHelpline]

That can be done either inside power query or in DAX. where you need to dynamically find the date of last Sunday of march or 2nd Sunday of March depending upon your region. then validate that date with your result date. and if your result date falls after that date then add 1 extra hour