I recently came across the error:
I was connecting a Current User Filter to an Excel Web Access Web Part I was trying to pass the User's Login Name via the Current User Filter to a Parameter in an Excel Web Access WebPart.
I first created a workbook that contained a Pivot Table and then gave one of the cells (which is a Filter) a Define Name (I called it "NameParameter").
You can see Cell B:1 (which contains the name "Tommy") is named (the cell's Defined Name) "NameParameter". You can also see the cell's Defined Name by clicking on the Formula tab > Name Manager.
To help you fully understand what I am doing, here is the Pivot Table data which is located on another worksheet in the same workbook.
I now need to save this to a SharePoint Library. While doing this, I need to make sure my Defined Name ("NameParameter") is published.
To ensure this choose Save As > Other Web Locations (Browse to the SharePoint Library) > Browser View Options… > Parameters tab > Add… (add the Parameter) > OK
Next I created an Excel Web Access Web Part via Insert > Web Part > Business Data > Excel Web Access
Then point to the workbook and publish > OK
Next I add a Current User Filter via Insert > Web Part
Filters > Current User Filter > OK
I now need to connect the Current User Filter to the Excel Web Access Web Part. To do this, click the dropdown arrow > Connections > Send Filter Values To > Excel Web Access
We know need to Select value to provide. I chose Name as you can see, I am logged in as MOD Administrator, so if I log into SharePoint as this account, this Name should be passed to the NameParameter!
Everything works, yay!
If the PivotTable's source data is a Data Model, this will not work. I am currently investigating this with our Product Team.