Not a legal OleAut date.. The exception was raised by the IDataReader interface

Question

I have an SSAS Tabular project and the tables are coming from an Oracle database based on queries. When I proceed with process all, everything is fine but when I try to deploy the solution, the metadata is created successfully on the server and then deployment fails with the following error :

Failed to save modifications to the server. Error returned: 'Not a legal OleAut date. The exception was raised by the IDataReader interface. The database operation was cancelled because of an earlier failure.

I am using System.Data.OracleClient which is an ADO.NET provider. 6I have a doubt it may be outdated since when I connect to Power BI I get this message :

I checked all the date columns in my tables but I didn't find any value which is invalid (outside the valid range 1-January-1900 to 31-December-9999).

Answer 1

I am using System.Data.OracleClient

That's the Microsoft data provider for Oracle.

As the PowerBI message says, i't better to use origin ODAC = "Oracle Data Access Provider, you get them here:

https://www.oracle.com/database/technologies/odac-downloads.html