How to check why Date and time settings different between UAT and Prod

(0) Share

Report

Posted on by bp3378

190

We have a UAT and PROD instance as our data source, I have a power bi report that connect to them. When I pull the data over to BI, the date and time fields from prod are offset to UTC time which from what i read is normal. However, The same BI report that also pulls from UAT (same table and field), the date and time does not offset, the date and times are the same as it is in dynamics.

Since I am using the same Power BI file to connect to these two data sources, I can rule out that it's not in the BI side that is causing this and it is from the Dynamics end. I checked the timezones that are set in Dynamics on both instances, and they are set to the same timezone. So Why am I pulling the date and times over and is offsetting differently?