Forum Discussion

rrodillas012's avatar
rrodillas012
New Member
1 year ago
Solved

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

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!

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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