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:


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


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.

This entry was posted in powerpivot, Syndication and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s