I use integrated PowerApps in a PowerBI report. One of the fields is DateTime. When this field is transfered to PowerApps it's automatically converted to Date, what means lossing time information.
Why this happens and how to fix it?
Thank you
Hi @Anonymous,
Experience this issue as well, couldn't solve it after few attempt to change the format. Any update from your side?
Hi Senzero,
Did you find any solution to your problem?
I am also facing the exact same issue as you mentioned, in Power Apps time is correct, but when we see it as integrated in Power BI, it shows default time as 12:00AM
Hello. I know this thread is a year old but I am experiencing the exact same issue that JanD2 has clearly outlined above. I do not see a solution. I would like to know why a Datetime field in Power BI dataset passed to the embedded PowerApps visual converts it to Date type. Moreover, when I use the following code:
Text(DateTimeValue(Gal_Selected_Anomaly.Selected.AckDate.Text, "en-US"))
I do get the correct time but when I save the Power Apps App and then go back to the embedded Power Apps visual in Power BI, I have lost the time component of the Datetime field.
In Power Apps:
In embedded Power Apps visual in Power Bi:
Please help. Thank you.
Hi JanD2
Thank you for your reply and the information. Were any changes recently made to the source data? Could you try to edit the app directly from the Power BI dashboard (as seen in this thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-BI-Integration-Data-not-showing/td-p/99841) and let me know if you continue to experience this issue?
Thanks again,
Rory
Hi Rory,
Thank you for your answer.
The thing is that I am passing DateTime information through PowerBIIntegration dataset. I don't have any visibility on this dataset when it comes to settings. Later on, when I want to use this column in PowerApps formula, it says it's a DATE type.
I am attaching 2 screenshots one from PBI and one from PAPPS.
Thank you
Jan
Hi JanD2,
Thank you for your post to the community. If you review the text property configured for the control, how is the Date and Time configured to be displayed in the app? You should be able to customize how this is displayed using the DateTimeValue function.
More information about how to do this is available here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/show-text-dates-times
More information about this function is also available here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-datevalue-timevalue
I hope this helps!
Thank you,
Rory
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2