cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Seraf
Regular Visitor

Summer time

Greetings,

Please advise. I have set the date/time/timezone in Power Querry according to the reginal settings, but the dates have not changed. Can you please advise me how to set it correctly?
Thank you for your help and time...

 

2021-06-23_9-55-07.png

4 REPLIES 4
v-stephen-msft
Community Support
Community Support

Hi @Seraf ,

 

This is the corresponding result. Did you not get such a result?

8.png

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Stephen Tao,
This result is wrong, it should be +02:00

Hi @Seraf ,

 

It is suggested to add New column with Added TimeZone, change the data type to DateTime and use this column.

Screenshot 2021-06-30 172404.png

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Raymundo2910
Resolver II
Resolver II

Follow the steps of this video: https://www.youtube.com/watch?v=M1zquwmpnZE 

Those helped me to solve the same issue you have. 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors