Problem with Power Query changing Dataverse Date only value

[Anonymous]

Hi all,

I have a problem with Power Query changing a Dataverse Date only value.

My Dataverse column is:

• Date type: Date and time
• Format: Date only
• Time zone adjustment: Date only

When I import it to Power Query, it is displayed as a DateTime column. The date is one day earlier than in Dataverse and the time is 9:00:00 PM. I guess this is because my local time difference to UTC is 3 hours.

So for example the date in Dataverse is 6/27/2023 and in Power Query it is 6/26/2023 9:00:00 PM.

I'm using the Power Query in Power Apps Dataflow if that makes a difference.

How can I solve this?

[Anonymous · Accepted solution]

Hi @Anonymous 

You can consider to add a custom column 

e.g 

[DateTime] + #duration(0,3,0,0)

Output

Best Regards!

Yolo Zhu

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