User Details Report - Time Zones & Calendars
C
Craig Bachelet
We are trying to build a user report via PowerBI which captures all of the user data as per the user details screens within builder to ensure the config is correct for each office location.
1.) Time zones: we have located the time zones via the following user table:
• Table: tblUsers
• Column: _Timezone
However, it does not give a full description of the selected time zone we see within builder. See the below example cases and screenshot attached:
• Within builder user management screens the time zone is ‘(UTC+00:00) Dublin, Edinburgh, Lisbon, London’ and on the report / within the data warehouse its ‘GMT Standard time’.
• Within builder user management screens the time zone is ‘(UTC) Coordinated Universal Time’ and on the report it’s ‘UTC’. Within the data UTC is not useful, as all times zones in builder start with UTC.
So please can you store the builder equivalent time zone description in the warehouse database.
2.) Please can the user calendar full description also be stored in the data warehouse as we are unable to locate this at the moment.
Sandana Thevar
Craig Bachelet Thank you for sharing your detailed requirements.
We understand your goal is to build a comprehensive user report via Power BI that mirrors the user details screen within the Builder, specifically for validating configuration accuracy across office locations.
To help us evaluate the request effectively, we would appreciate a bit more context around the following points:
Time Zone Description
We understand the current format in the warehouse (e.g., "GMT Standard Time", "UTC") doesn’t fully align with the user-friendly format seen in the Builder UI (e.g., “(UTC+00:00) Dublin, Edinburgh, Lisbon, London”).
Could you please confirm how the detailed time zone descriptions will be used in your Power BI report?
Is the goal to simply match the UI for validation purposes, or are there reporting/logical conditions being applied based on the full description?
User Calendar Description
You’ve mentioned you’re unable to locate the full calendar description in the warehouse.
Could you help us understand how you plan to use this data in your reporting?
Are there specific fields from the calendar (e.g., working hours, working days) that are essential for your use case?
Are you trying to verify user scheduling configurations per office, or is this tied to SLA/time zone reporting logic?
Once we have this information, we can better assess the impact and prioritize accordingly. In the meantime, if there’s any workaround using the API or current metadata, we’re happy to assist.