Forum Discussion
Set local time zone Power BI Service
For those with access to a SQL Server instance, use DirectQuery from a SQL server data source and paste the following T-SQL:
SELECT CONVERT(Time, GETDATE())
This will use the database time zone. Set the page in Power BI service to auto refresh visuals every minute (or more), make a card with this sole column, and you will have the current time in your local time zone.
If making measures to account for daylight savings with time oriented data, create a table from SQL server witht the following code:
--Daylight Savings check
SELECT * FROM sys.time_zone_info
Where name = 'Central Standard Time'
Obviously, use the time zone of your preference/choice. You will return a row of data, including a column that tells whether or not you are in daylight time. You can then write measures in two parts, IF(is_daylight_time = False, blah blah..., ELSE insert different parameters for when it is daylight time. You can also create a UTC offset adjuster from this that is dynamic based on the second column, wich is offset.