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?
- I'll try a demo tomorrow.
Also to your React question: PowerBI hands your custom visual a dataset which you can then manipulate as you like.
So ... essentially..if you can generate the table to correctly "model" the offset calculation, you'd already have the problem solved. How does this fix the date issue?
