I use SharePoint 2013 and Excel Services and SSAS
I load an Excel file to SharePoint Document and then I use that in Performance Point Service to create an Excel Report. I then use this report to a Dashboard and finally deploys my Dashboard to SharePoint.
Note : I use a connection in Excel file for querying data from SSAS.
My report is like this picture :
But when I click in my Excel Object , I get this message :
Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source.
Do you want to refresh the workbook?
And after press the Yes button I get this error :
The data connection uses Windows Authentication and user credentials could not be delegated. The following connections failed to refresh:
How I can fix this error?