![]() Hope this helps, and please share your findings. The full version costs $580 and may well be worth it.Īnother issue you may face with this OLE DB driver is if you need Mac support. Note that the trial version of the OLE DB provider limits the results to 100 records and you can only view a limited number of tables via Powerpivot. ![]() It may well be worth it depending on your scenario, unless Amazon adds Powerpivot support to their ODBC driver. I plan on trying out the full version of the OLE DB provider in the next week or so. I did stumble upon and try the trial version of an OLE DB provider for Redshift from and have been successful in pulling data from Redshift into Powerpivot. 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. The November Power Pivot for Excel 2013 update delivers a better experience when using Power Query with Power Pivot as well as support for Key Performance. 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. ![]() D Dheeraj Member 6 Thanks for the information. Note: Excel 2010 PowerPivot isn't compatible with Excel 2013. I believe it was Standalone Excel, Pro Plus and Enterprise licenses.
0 Comments
Leave a Reply. |