Date in Power BI Table does not match date in VSTS

[MarcoUrbanic]

I am access a query in VSTS using Azure DevOps as the data source from Power BI.  The date fields in Power BI are not matching up to what is in VSTS.  For example:

Desired date in VSTS is 4/27/2019 12:00 am

Desired date showing up in Power BI table is 4/26/2019 12:00 am

Maybe something to do with timezones?  But I can't figure it out.  I need the date to be the same in Power BI exactly as it is in VSTS.

Thanks in advance for any help!

[v-yuta-msft · Accepted solution]

@MarcoUrbanic ,

Click query editor-> Add custom column then using power query function like below:\

DateTimeZone.SwitchZone(#datetimezone(2010, 5, 4, 6, 5, 5, 0, 0), 😎 equals #datetimezone(2010, 5, 4, 14, 5, 5, 8, 0)

Reference: https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone

Community Support Team _ Jimmy Tao

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