web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : W5oCZfR39GFEPbi/qCa9Ss
Power Apps - Building Power Apps
Unanswered

PowerBI to PowerApps converts DateTime to Date automatically

Like (0) ShareShare
ReportReport
Posted on 25 Mar 2020 21:00:48 by 4

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

Categories:
  • alex_limzeeh Profile Picture
    2 on 29 Dec 2021 at 03:56:12
    Re: PowerBI to PowerApps converts DateTime to Date automatically

    Hi @Anonymous,

    Experience this issue as well, couldn't solve it after few attempt to change the format. Any update from your side?

  • Community Power Platform Member Profile Picture
    on 02 Jul 2021 at 07:07:43
    Re: PowerBI to PowerApps converts DateTime to Date automatically

    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

  • senzero Profile Picture
    6 on 10 May 2021 at 21:07:59
    Re: PowerBI to PowerApps converts DateTime to Date automatically

    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:

     

    senzero_0-1620680714395.png

     

    In embedded Power Apps visual in Power Bi:

     

    senzero_1-1620680848144.png

     

    Please help.  Thank you.

     

  • roryl Profile Picture
    on 30 Mar 2020 at 20:20:09
    Re: PowerBI to PowerApps converts DateTime to Date automatically

     

    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

  • JanD2 Profile Picture
    4 on 28 Mar 2020 at 12:18:57
    Re: PowerBI to PowerApps converts DateTime to Date automatically

    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

  • roryl Profile Picture
    on 27 Mar 2020 at 20:40:04
    Re: PowerBI to PowerApps converts DateTime to Date automatically

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete