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

Torbennb's avatar
Torbennb
Frequent Visitor
1 year ago

Thank you very mudh Vinay.

I can do that but the value is set to 00.00.00 and not to the actual hour.
In database the hour is stored and visual

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Torbennb,

     

    The issue is not with Power BI.
    Power BI displays exactly what it receives from the OData service. If the time shows as 00:00:00, it means the OData feed is sending only the date, even though the database stores the full datetime.

    This usually happens when the OData service truncates or casts the datetime to just a date in its model.
    To fix it, the column needs to be exposed as a full datetime in the OData metadata.

     

    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