oracle-databasevisual-studiossas-tabular

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

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.

enter image description here

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 : enter image description here

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).

Solution

  • Change the driver. System.Data.OracleClient is deprecated for 12 years at least even though the actual documentation has recent modification dates. Even the ODBC and OLEDB drivers provided by Microsoft have deprecation warnings. All those drivers still exist to avoid breaking old code.

    At the very least, try using Oracle's ODBC, OLEDB or .NET drivers instead.