Forum Discussion

alexbjorlig's avatar
alexbjorlig
Icon for Helper IV rankHelper IV
2 years ago

Is it possible to load a DateTime column into Power BI from OData v4?

I'm a developer of an OData API, and also a Power BI maintainer. When I return a column like this in OData:   <Property Name="Date" Type="Edm.DateTimeOffset"/>     Power BI always parse...
Need Help
alexbjorlig's avatar
alexbjorlig
Icon for Helper IV rankHelper IV
2 years ago

Hi there, thanks for trying to help.

If I format the date as ISO 8601 "2024-05-30T12:00:00" format, I get the following error:


DataSource.Error: OData: Cannot convert the literal '2024-05-01T00:00:00' to the expected type 'Edm.DateTimeOffset'.

 

And yes, I can convert the column after loading the data into Power BI, but then I can't fold the query!