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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |