I have an issue with SharePoint 2013 Excel Services using Analysis service. My SharePoint site has Forms Based Authentication and I need to set user level permission to this users in the Cube.  I solve this by passing the username as a 'custom data' to the cube role from excel service embedded connection string. But I can't edit this connection string dynamically from Excel Web Access. 

Is there any way to handle the session directly from the cube or edit the connection string of the excel web access dynamically for each session .

• Moved by Fei XueMicrosoft contingent staff 5 hours 1 minutes ago

Hi RehnaHaridas,

Thanks for posting in MSDN forum.

This forum is for developers discussing developing issues involve client Excel application like Excel customization and automation.

Since the issue is more relative to SharePoint developing, I would like to move it to SharePoint 2013 development forum.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Regards & Fei