Forum Discussion

Torbennb's avatar
Torbennb
Frequent Visitor
1 year ago
Solved

OData date day and hour

I connect data with Odata from Azure database. When I add date fields, I looks like it only take the date value and not the hours value. Any way to configure this??    
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Torbennb,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Vinay Pabbu

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Torbennb,

 

Thank you for reaching out to Microsoft Fabric Community Forum.

 

In Power BI, datetime fields might sometimes show only the date because the system automatically converts them to the Date type during data load.
To resolve this, go to Transform Data, open the column in Power Query, and manually change its data type to Date/Time to ensure both date and time are retained.


Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to give "Kudos"

 

Regards,
Vinay Pabbu