Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Oracle Date issues with PowerPivot

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.


Comments

Leave a comment on the original post [mikedavissql.com, opens in a new window]

Loading comments...