Is there any way I can change the timezone of the PowerBI Service?
I read that it is effectively set at UTC which would explain why when I use TODAY() and YESTERDAY() DAX in my PBIX reports, they are fine locally, but clearly out of sync when they are published to the web service.
Solved! Go to Solution.
I was having this issue where the times that showed in local time zone on my PowerBI Desktop, turned into UTC when published on cloud service. I was able to solve this by first adding a local timezone as table (see Showing Specific Timezones in Power BI Service (Last Refreshed Time) - YouTube). And then mark the resultant table as a Date Table as shown below. Once it is marked as a date table, it almost resets the time zone on your power bi service to local.
P.S. This also worked on PBI Report Server where I was having the same issue.
Using a custom column does not work if the time zone has 'Daylight saving' as the date on which the hour goes back or forward changes twice a year
In this case you must use API service to get the correct time, kinda crazy you need to get an api to external service to solve this, Microsoft should provide this as part of it's cloud service to supports demands and calls from the service
See this document fr the difernet options , method 3 is your best bet if you are in a zone with daylight saving https://radacad.com/solving-dax-time-zone-issue-in-power-bi
There no such thing as minus 3 timezone. Time zone have a name to take account of the summer / winter time difference with UTC.
There is currently no way to change time zone in Service. This other thread has some links with additional suggestions: https://community.powerbi.com/t5/Service/Set-local-time-zone-Power-BI-Service/td-p/114120
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.