Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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