PowerBI DirectQuery, Date and Time conversion from UTC to UTC+13

[rrodillas012]

Hi Good Day!

I'm creating a dashboar on PowerBI Desktop using Dataverse DirectQuery. Upon checking power query the date and time is in UTC. 

Tried editing using power query but it's not possible since it's directquery from Dataverse(dynamics 365)

How would I convert the date and time from UTC to UTC+13? What would be the workaround here, Thank you!

[Anonymous · Accepted solution]

Hi @rrodillas012 ,

I've made a test for your reference:

1\My dataverse table(Direct Query mode)

2/Add 13 hours to the createdon field using Table.TransformColumns in Power Query.

    NewTable=  Table.TransformColumns(dbo_cr07c_newtable, {"createdon", each _ + #duration(0, 13, 0, 0)})

3\Result

Best Reagrds,

Bof