Forum Discussion
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 possibl...
Hi rrodillas012 ,
I've made a test for your reference:
1\My dataverse table(Direct Query mode)
2/Add 13 hours to the
createdonfield usingTable.TransformColumnsin Power Query.NewTable= Table.TransformColumns(dbo_cr07c_newtable, {"createdon", each _ + #duration(0, 13, 0, 0)})3\Result
Best Reagrds,
Bof
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