Column in PowerBI Integration Showing as Date not DateTime

[Anonymous]

Hello Everyone, 

I have a subtle problem where I am trying to pass a datetime object from my Oracle database in PowerBI into a PowerApp. The issue is that when I do so, the column is being converted into a Date object instead of the DateTime datatype. This is causing the time to get truncated when I attempt to put the object into a label of a gallery. 

# Proof the field is Date/Time in PBI

#Showing the timestamp of the column in a PBI Table

# Showing the datatype of the field in PowerApp (I think this needs to be DateTime)

# Formula for the TEMP_TS column in the gallery (Also tried DateTimeValue formatting and using ThisItem.TEMP_TS)

# Proof the time is getting truncated

[aj1973]

Hi @Anonymous 

Not sure if this could help but the best practise in Power Query/Power Bi is to separate/split Datetime column into 2 columns Date and Time. 

[Anonymous]

Will implement this today and let you know of the results. Do you have any resources that indicate this is the best practice? Interested to learn more. Thank you. 

[aj1973 · Accepted solution]

https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/