Excel Online Cross Forest KCD Data Refresh Not Supported

Scenario: You configure Office Online Server with SharePoint 2013 or SharePoint 2016 and have configured Kerberos Constrained Delegation to a data warehouse to pull business intelligence data for your users. You have two Active Directory domains in separate forests in a 2-way transitive trust configuration (We will call them DomainA in Forest 1 and DomainB in…

0

Excel Services - Query Warning

   You may receive the following warning dialog box when opening a workbook using Excel Services in SharePoint:     Be careful. This workbook contains one or more queries that might be unsafe. Do you want to enable these queries?   To suppress this and other warnings from Excel Services, go to SharePoint Central Administration…

9

Excel Web Access WebParts fail to refresh in Team Foundation Server Dashboard.

I have worked with many customers who are seeing refresh failures in the Excel Web Access Web Parts in their TFS Dashboard. In most cases, this is caused by not having a Secure Store Service ID set up for Team Foundation Server and that SSS ID has not been added to the Enterprise Application Definition. …

1