Sharepoint Online (O365 E3 Plan) and Excel 2013.
Hi, I created Power View in excel using data from our CRM. I exported data from our CRM, created a PowerPivot table from the data, run a few functions and from there created a Power View Sheet. From there I was able to display the Power View sheet on SharePoint using Excel Services web part.
The challenge that I am having is I would like to automatically filter the data based on the user that is logged in. Also it is important that the user not be able to change the filters and see other users data.
Is this possible?
I have already tried using Current User Filter and passing the user information, but for the life of I can't figure out how to have the power view accept it as a filter. Thanks in advance for any help.