Forum Discussion
Report Refresh Date - Azure Dev ops connection
Hi Guys
I have a report which connects to VSTS - using online services (Azure dev ops - Beta). I added a custom column using datetime.localnow in power query. This column will be used to display report refresh time.
Its works fine on desktop. But in Power BI service it gives me date in UTC format once the data is refreshed in Service.
Any tips how can it is displayed in local time zone.
Hi Anonymous
You could find the solution in the following link.
Display Last Refreshed Date in Power BI
Or
Power BI – Create Last Dataset Refresh Date
If consider Daylight Savings Dates and Times change, follow this link:
Using Power BI to ensure Daylight Savings Dates and Times change dynamically
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous
You could find the solution in the following link.
Display Last Refreshed Date in Power BI
Or
Power BI – Create Last Dataset Refresh Date
If consider Daylight Savings Dates and Times change, follow this link:
Using Power BI to ensure Daylight Savings Dates and Times change dynamically
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I'd try converting it with the DateTimeZone functions, e.g.
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzoneI was thinking to calculate the delta with hardcoded DateTimeZone value for UTC and your time zone, using this:
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-fromtextbut it would still not cover the daylight savings automatically
I'm out of ideas, but maybe ImkeF can help?
