Power Pivot Data Import Error : Need Help

I am able to connect to the RedShift ( Amazon ) Database using ODBC and I can import Data in Excel 2013. When I am trying to import Data using PowerPivot ,  I can make the ODBC connection and also run query and review the tables , but when I try to Import it errors out and I am getting below error . Even I am able to Validate the Query. I am using 32 bit office 2013 . 

OLE DB or ODBC error: ODBC driver does not support the requested properties..

An error occurred while processing table 'Query'.

The current operation was cancelled because another operation in the transaction failed.

Thanks,

Alok Tanna

April 24th, 2015 12:40am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics