Forum Discussion
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??
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
6 Replies
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 PabbuHello Torbennb,
Just wanted to drop a quick note, were you able to resolve the issue you raised?
If so, it would be really helpful for the community if you could mark the answer that helped you the most. If you're still looking for guidance, feel free to give us an update, we’re here for you!Regards,
Vinay Pabbu
Thank yo very much Anonymous .
It helped me to understand then the hour were removed in the Power BI setup. Data were pulled right into the report from o-data.
So challange was then the previously developer of the report has removed the hours.Torben
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 PabbuThank 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 visualHi 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
