Power Pivot Data Import Error (Network Steve Forum)

Power Pivot Data Import Error

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 23rd, 2015 11:02pm

Thanks,

Alok Tanna

Merged by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, April 27, 2015 6:14 AM duplicate

Free Windows Admin Tool Kit Click here and download it now

April 24th, 2015 4:38am

Hi Alok Tanna,

According to your description, you can use ODBC to import data to excel, but cant import to PowerPivot. It seems that we could import data into Excel 2013 by using ODBC when connecting to RedShift ( Amazon ) Database, but we could not ensure import data into PowerPivot is fine. Maybe this operation occur errors.

I suppose you need to contact administrator of RedShift ( Amazon ) Database for helping. And you can post your issue to PowerPivot forum, I think that forum can offer more professional answers about PowerPivot. Thank you for your understanding.

The forum of PowerPivot:

https://social.technet.microsoft.com/Forums/office/en-US/home?forum=sqlkjpowerpivotforexcel

Regards,

Edited by guGuuuMy 18 hours 7 minutes ago

April 29th, 2015 4:50am

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