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 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 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 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/9...) and let me know if you continue to experience this issue?
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:
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.
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
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.