Sukumar Chittooru on 05 Aug 2021 16:03:20
UTC date column in the power bi should be converted to local time of an user dynamically. For example, if user access a report from PST time zone, the UTC column should be converted to PST and if accessed from EST time zone, the report should show EST time. I believe this feature is currently not available.
It will great to have this feature as users would find it easy to read the time columns in the reports.
- Comments (9)
- Merged Idea (3)
RE: UTC to Local Time Conversion in Power BI service
I use the DateTimeZone.ToLocal function in PowerQuery with good results. If i publish from PowerBi desktop to cloud, it working fine also. But when I use personnel Gateway to plannify update, time in localTimeZone is the same as UTC time.
RE: UTC to Local Time Conversion in Power BI service
it's beyond ridiculous that there is not a solution for this in Power BI yet after all these years. It's the biggest PITA having to always come up with solutions to make sure reports show local time and handle day light savings time etc... Please , please implement a solution for this.
RE: UTC to Local Time Conversion in Power BI service
We have an alternative solution, where we can build a custom column in Power BI Model with Import mode of connectivity to change UTC time zone based on the requirement, however the same won't work with Direct Query mode as we cannot build custom column, need some implementation for the same in future updates.
RE: UTC to Local Time Conversion in Power BI service
Please, please, please, allow us to have our Power BI online cloud environment to reflect our dates according to our set time zone instead of forcing it to use UTC time. This is extremely frustrating to deal with.Thank you for your time.
RE: UTC to Local Time Conversion in Power BI service
We need to show the last synced date and time on reports. I have a method that returns the last sync time. While it initially displays my local time, in short order it changes that to show the sync time in the UTC zone. This is working as expected according to my research.
What I am seeking is a way to take the time returned by a PowerBI query which is UTC and read the local time zone from the user's machine and then apply the adjustment to a new quick measure to show the user local time.
I am not a DAX coder and my attempts to do this have failed. Basic time math works, but I am insufficiently skilled to figure this out and I need it on a number of reports so a function or standard calculation would be superior.
Thank you
RE: UTC to Local Time Conversion in Power BI service
For crying out loud...fix this UTC time issue already!!!
RE: UTC to Local Time Conversion in Power BI service
This is a feature which we definitely need. We use an Azure Data Explorer to store data from globally spread sites. To have a single data schema we store them in UTC format. But of course our customers like to see their data in their local time.
RE: UTC to Local Time Conversion in Power BI service
I need this as we publish reports to all parts of the globe and the users complain that I show the last update on shared datasets in UTC time.