Date is showing different on Power BI service than data source

[Anonymous]

Hi Team,

I am facing weird issue. I am importing data from Snowflake table to Power BI desktop file and publishing to Power BI service. When I publish the file to Power BI service then it shows different date [one day backward].

Below is detailed description of issue with an example.

Date in snowflake table: 11/15/2021 00:00:00

Date in Power BI Desktop: 11/14/2021 17:00:00

Date in Power BI Service: 11/14/2021 17:00:00

I am in UTC + 1 timezone and my Power BI service account time zone is also same.

Data is stored in: Southeast Asia (Singapore)

It's 

[v-yingjl]

Could not reproduce it in my side as far as my test. Seems like the datetime in Snowflake shows the local time in Power BI(Snowflake Singapore is UTC +8, your local time is UTC +1).

I have created a snowflake sample datasource which data stores in Japan East(UTC +9) while my local time is UTC +8 but the datetime shows the same in Snowflake and Power BI.

Perhaps you can try to convert the timezone in Snowflake to local and check it again in Power BI, refer:

CONVERT_TIMEZONE 

Best Regards,
Community Support Team _ Yingjie Li

[noratolgyesi]

I have the same issue. 

Snowflake dates are stored in UTC but imported to Power BI, the local time shows up. And Power BI recognises that: when the date field is change to Date/Time/Timezone, it shows the time difference from UTC.

Is there any way to fix this?