May be this is what amirbehzad is referring to? Note that a non-powerpivot connection (via Data > From Other Data Sources > Data Connection Wizard) is successful via the Amazon ODBC driver. I too had the exact same problem, and stumbled onto this thread, having being unsuccessful in connecting Powerpivot to Redshift via the Amazon ODBC driver or the Postgres 8 driver (as suggested by an AWS engineer). So it's not due to a basic issue like login or driver. I am able to download the data to Excel when I am not using Power Pivot: the download works perfectly well from the DATA menu in Excel. The current operation was cancelled because another operation in the transaction failed. An error occurred while processing table 'xxx'. ODBC driver does not support the requested properties. I then get the error : "OLE DB or ODBC error. Select the table that I want to connect to, from the list shown.Connected to my Redshift database (the test connection works).I have tried to connect it to Power Pivot as follows:
The database that I need to analyze is in Amazon Redshift (it is an export from Amazon Mobile Analytics). Hi: Has anyone ever managed to connect a Amazon Redshift database to Power Pivot in Excel 2013? It does not seem to work and from my online searches, I found that many people are facing the same issue.įor business intelligence / reporting purposes, I am using Power Pivot as an add-in for Excel 2013 on Windows 10 (32 bit version of Excel).
0 kommentar(er)
