Forum Discussion
Incorrect Time Zone setting at Power BI Service
Hi raymondwkmok
The Power BI service only operates in the UTC time zone, you need to adjust dates & times in DAX or Power Query.
There are lots of resources on this these few may help..
Dynamic time zone conversion using Power BI – The White Pages (unlimitedviz.com)
Power BI Service Time Differences and How to Fix It (linkedin.com)
Showing Current Time and Latest Refresh Time at Local Timezones in the Power BI Report - RADACAD
Hope this helps
Stuart
Dear Prajwalkumar
The problem is getting the local user's time to Power BI. Power BI only shows UTC. In your answer above, it is the TIME(5,30,0) that needs to be sent to Power BI. This value will be different depending on where (and when for GMT/BST) the user is located, so it is not a fixed value. We want Power BI to know where the local user is, who is running the report.
Regards
ProfPlat