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 a...
amitchandak
Super User
Super UserThanks 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