We are having an issue with authentication when using the Spotfire SharePoint Connector. This feature has been added to our Spotfire 6.5 environment and allows direct access between SharePoint and Spotfire. Firstly, to create Spotfire reports using SharePoint lists and also allows for reports built on Excel spreadsheets stored in SharePoint to be viewable using the Spotfire Web player (provided the Spotfire Admin account has Power User access to the SharePoint site/library where the content is located). By default reports built using .xlsx in SharePoint do not display in the Web Player due to an authentication issue.
We have solved the problem with the web player not working for some Spotfire reports based on .xlsx documents stored in SharePoint (using the SharePoint Connector in 6.5). The Spotfire Admin account needs to have access to the site that stores the .xlsx and for some reason this wasn’t working when the access was granted via a SharePoint permission group – access needed to be granted directly to the site. See below:
When the account was in the BI Power User group reports based on content in this site were not working in the web player. Changing to the above the reports are working in the web player.
Note in these two cases I have granted the account Read access. If Spotfire analyses are configured to connect directly to a list and include update functionality Spotfire Admin will require Contribute access.
tags: SpotFire SharePoint Connector – error web player,