Forum Discussion
Dataflow - Data Transform is not working when pulling table in Power Bi
Here is what we are doing... I have two SPO lists. One is static, never changes. The other is where we assign cases. At the end of each day, the goal is to pull this data into the dataverse, then...
You can use DAX to add offset hours to datetime values to achieve the same result. For example,
CST time = 'Table'[UTC time] - (6/24)This is supported in DirectQuery.
If you choose Import to connect to the same table in Dataverse, does the CST column display correct CST datetimes?
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.