Forum Discussion
Supporting Multiple Timezones in Power BI Report
Background:
- We have are building a SaaS solution that is pulling data from a 3rd party system and storing all of the extracted data inside of an Azure SQL DB.
- The source system is multi-lingual and supports all TimeZones, so any user can login to the platform and run a report or view data in their local TimeZone.
- In Power BI, we need to be able to present the data, metrics and calculations in the TZ of the user so the data will match what they see in the App
Problem:
- How the heck do I do this?
- We're able to manipulate the Source Queries to receive a TZ Parameter and convert DateTime in T-SQL but that is still limited to 1 TimeZone
Any Thoughts:
- I considered summarizing data by TZ, which will create a fair number of extra rows and then using a Slicer for the user to view the data in their local TZ
4 Replies
Did you ever find a solution? I have the exact same issue, except my users can be all over the world.
cdub509 - I just stumbled across this post and Avi has a solution that should solve this problem:
- amitchandak
Super User
Thanks for the response, I saw the Reza Rad post before but I don't think that will work in this case.
The raw data is like this, there is not a UTC Offset
User Start DateTime End DateTime Duration(s) User A 6/10/2020 1:00:00PM UTC 6/10/2020 3:17PM UTC 136 User A 6/10/2020 3:17PM UTC 6/10/2020 3:30PM UTC 13 User A 6/10/2020 3:30PM UTC 6/10/2020 6:17PM UTC 320 When Manager A runs the report for this data, the data should be returned/represented in CST
When Manager B runs the report for this data, the data sould be returned/represented in EST
Eventually we will be grouping this data by Day, Hour and 15m increments
