Forum Discussion
Convert column from etc to local timezone in Get Data Process
Hi, I am performing the get data process from Dataverse and wondering how to convert to UTC+10? I was thinking it should be done at the ingestion level without having to create a measue. Ive tried...
Hi Tango2310
You may not be able to do this in DirectQuery mode.
In DirectQuery mode, the data remains in the source system, and Power BI sends queries to the source system to retrieve the data.
This means that, ideally, complex transformations should be handled at the source.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.