Forum Discussion

lardo5150's avatar
lardo5150
Microsoft Employee
4 years ago
Solved

Power Apps 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...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, lardo5150 

    So you mean the date/time/zone are not displayed correctly in Power BI.

    After loading the other two tables into Power BI as well, is the time zone of the column displayed correctly, and is the date time zone of the other columns(UTC) displayed correctly?

     

    Try to add a time zone and then convert the time zone to UTC and then switch the time zone, that is, add a step to convert the time zone to UTC in the above steps.

    A=DateTime.AddZone([AssignmentTime], X)

    B=DateTimeZone.ToUtc(A)

    C=DateTimeZone.SwitchZone([UTCTimeZone], Y)

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, lardo5150 

So you mean the date/time/zone are not displayed correctly in Power BI.

After loading the other two tables into Power BI as well, is the time zone of the column displayed correctly, and is the date time zone of the other columns(UTC) displayed correctly?

 

Try to add a time zone and then convert the time zone to UTC and then switch the time zone, that is, add a step to convert the time zone to UTC in the above steps.

A=DateTime.AddZone([AssignmentTime], X)

B=DateTimeZone.ToUtc(A)

C=DateTimeZone.SwitchZone([UTCTimeZone], Y)

 

 

Best Regards,
Community Support Team _ Zeon Zheng


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.