Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

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...
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi Syndicate_Admin 

 

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.