Forum Discussion
Difficult Question: Dynamic Time Zones with Power BI Embedded, Direct Query, and RLS
I've been turning this thing over in my mind for the past week. Here's the challenge, and I'll state it from the perspective of a report user ... "As a user I need to be able to see my data, on a...
Slightly less crazy idea
Create a minute only table with 24 columns, 1 per TZ offset and a column indicating which one is the first on or after midnight.
You should be able to reverse engineer from a user TZ to the fact table offset and also generate the local TZ display value from that?
Create a minute only table with 24 columns, 1 per TZ offset and a column indicating which one is the first on or after midnight.
You should be able to reverse engineer from a user TZ to the fact table offset and also generate the local TZ display value from that?
How does this fix the date issue?