Forum Discussion

Don-Bot's avatar
Don-Bot
Helper V
1 year ago

Modify Timezone for apps own data power bi embedded model

I have a apps own data power bi embedded semantic model setup.  The model itself is an import model that is setup as a star schema.  Multiple clients and multiple users across different timezones uti...
Need Help
SacheeTh's avatar
SacheeTh
Resolver II
1 year ago

Hi Don-Bot ,
Yes, your understanding is correct. Unfortunately & as far as I know, Power BI does not natively auto-detect or dynamically adjust time zones for individual users in the Power BI Service on the report end. If your model has users across multiple time zones, pre-configuring time zones with extra columns (e.g., "CST", "PST", "EST") is one of the most straightforward approaches.

That's the only this that pop to me right now, other than user wise RLS or OLS.

Implement Row-Level Security (RLS)

If each user's time zone can be determined from their identity (e.g., region in a database), you can implement Row-Level Security to filter or adjust time zones dynamically based on user roles.

 

 

SacheeTh's avatar
SacheeTh
Resolver II
1 year ago

Ah on the 2nd through, you can set up a DAX for that too, I know you also have came a cross on this for sure. Anyway I'll add the steps here. 😄

Use DAX for Dynamic Calculations

If you need user-specific flexibility, consider calculating offsets in DAX. While this won't detect the user's system time zone, you can provide a slicer or control for users to select their time zone.

  1. Create a Time Zone Table:
    • A simple table mapping time zones to that has all the offsets:
       
      Time Zone| Offset
      EST-5
      CST-6
      MST-7
      PST-8
  2. Create a Slicer:
    • Add a slicer to the report for users to select their time zone.
  3. Create a DAX Measure:
    • Use the selected offset to calculate the adjusted time:

 

AdjustedTime = 
 VAR SelectedOffset = SELECTEDVALUE(TimeZone[Offset], 0) 

RETURN 
 UTCDateTime + (SelectedOffset / 24)

 

  • Display this adjusted time in visuals.