Forum Discussion
Automatically change in time zone
I have a report and there is a column in datetime format. This column comes from sql database and at the database level the time zone for this column is converted from UTC 0:00 to CST -5:00. When i publish this report to power bi services, then the column shows CST timestamp but when the report is refreshed it automatically converts to UTC.
I don't want this conversion of time. what should i do?
Hi, Swapnilshirke
To prevent this conversion, you can try changing the data type of the datetime column in your SQL database to a string or text format before importing it into Power BI. This will prevent Power BI from interpreting the datetime as a timestamp and automatically converting it to UTC. Alternatively, you can try setting the time zone for the report to CST in Power BI to ensure that the datetime column is displayed in the correct time zone. You can do this by going to the "Modeling" tab in Power BI and selecting "New measure" and then using the DAX formula to convert the UTC time to CST.
Please refer to the following links in the hopes of helping you.
Conversion UTC to local time date - Microsoft Power BI Community
How to convert UTC into Local Time Zone in Power BI Report using DAX? - PowerBI Talks
Converting UTC to local datetime in Power BI – Cloud BI
Convert UTC to Local Time in Power BI - IntelliTect
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi, Swapnilshirke
To prevent this conversion, you can try changing the data type of the datetime column in your SQL database to a string or text format before importing it into Power BI. This will prevent Power BI from interpreting the datetime as a timestamp and automatically converting it to UTC. Alternatively, you can try setting the time zone for the report to CST in Power BI to ensure that the datetime column is displayed in the correct time zone. You can do this by going to the "Modeling" tab in Power BI and selecting "New measure" and then using the DAX formula to convert the UTC time to CST.
Please refer to the following links in the hopes of helping you.
Conversion UTC to local time date - Microsoft Power BI Community
How to convert UTC into Local Time Zone in Power BI Report using DAX? - PowerBI Talks
Converting UTC to local datetime in Power BI – Cloud BI
Convert UTC to Local Time in Power BI - IntelliTect
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-zhangti Thank you for the solution. We resolve the issue by converting the datatype of the column from DateTimeOffset to datetime at SQL server.
