Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Powerbi integration with powerapps datetime issue

i have a problem with datetime in power app which data source is Power Bi through powerbiintegration. The date is not displayed properly in Power BI report. The format is datetime in Power BI. In the power app editior the date after using datetimevalue is dispalyed properly but in Power Bi report, the time in the date is 12:00AM. Even though the date is correct the time is always 12:00AM. Do you have any idea why is that? 

 

I have used daettimeoffset(7) in sql server table for datettime column. And powerbi daettime is displayed as 

Power BI DateTimeOffset2.png

From Powerbi, editing powerapps in editor, time is shown correctly. But whereas the same app when seen from powerbi embedded tile. Time is always shown as 12:00 A.M or it shows only date.

 

Someone please help me out. 

 

Status: Investigating
Comments
Anonymous
Not applicable

Hi @daisy_yrtttttt ,

 

Please try this in power apps:

DateValue( Startdate.Text )

 

For more you may refer to:

DateValue, TimeValue, and DateTimeValue functions in Power Apps - Power Platform | Microsoft Learn

 

 

Best Regards,
Community Support Team _ Caitlyn