We installed Panorama Nova View Flash 6.2.5 and wanted to use it to connect to PowerPivot. While beginning the work, we couldn’t connect
to the PowerPivot files and would get an error message. My colleague Tomer Horev was in charge of SharePoint installation and also found the following solution.
We understood what the problem was through the help of Panorama support. We tried to connect to the cube that’s created for our PowerPivot file through the Management Studio. That meant connecting to the SSAS DB with the name of:
We failed to connect and got a 401 error message of:
401 – Unauthorized: Access is denied due to invalid credentials.
We understood that the application didn’t recognize the user.
Since the user could access and view the PowerPivot file and the PowerPivot cube, we could assume the problem is with the connection between the file on the SharePoint Server and the cube on the PowerPivot SSAS Server. That meant checking the authentication definitions for the PowerPivot service on the SharePoint server. We found the following post about problem connecting to PowerPivot from Report Builder or Excel. That had the solution to our problem as well!
Go to the config file of the PowerPivot service: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\isapi\PowerPivot\web.config
There you need to change all 4 basicHttpBindings at the top to clientCredentialType = “Windows” and also changed the 2 customBindings to authenticationScheme = “Negotiate”.
After that, we could create Panorama views on top of our PowerPivot on SharePoint cube.