Supporting Multiple Timezones in Power BI Report

[Anonymous]

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

[cdub509]

Did you ever find a solution?  I have the exact same issue, except my users can be all over the world.

[Anonymous]

@cdub509 - I just stumbled across this post and Avi has a solution that should solve this problem:

https://community.powerbi.com/t5/Desktop/Difficult-Question-Dynamic-Time-Zones-with-Power-BI-Embedde...

[amitchandak]

@Anonymous , refer if these can help

https://www.poweredsolutions.co/2019/10/21/handling-different-time-zones-in-power-bi-power-query/

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

[Anonymous]

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