I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error message: 'An error occurred while attempting to set one or more of the parameters in this workbook.'

I have changed the data source to be just a table in the excel workbook and the filter works fine. So the issue only appears when using an SQL data source.

So my question is, is this a limitation of sharepoint or do i have an issue with my setup?

I am running sharepoint 2010, sql 2008 R2.

Thanks in advance!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.