http://www.sqlservercentral.com/blogs/mikedavissql/2012/05/29/oracle-date-issues-with-powerpivot/

Printed 2014/08/02 12:45AM

Oracle Date issues with PowerPivot

2012/05/29

This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the below error when trying to import:

OLE DB or ODBC error: Accessor is not a parameter accessor..

Out of line object Datasource referring to id ….

Out of line object datasourceview … temp_dsv

Here is the image:

clip_image002

None of this error made any sense. It was just a table in Oracle we were trying to pull from. After some troubleshooting I was able to find that a date column was causing the issue. Upon further digging we found that it was dates that had the year set to ‘0001’.

clip_image002[5]

So you will need to use a query to convert these bad dates to a valid year, like 1900 or something similar when pulling data from Oracle with PowerPivot.



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.