Forum Discussion
Automatically change in time zone
- 3 years ago
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.
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.