Unable to load data using SharePoint Online connector in Spotfire WebPlayer

Product: Spotfire Web Player

Summary:
This article explains why Web Player fails to load data using SharePoint Online connector.

Details:
To be able access SharePoint Online data in the Spotfire web clients (such as Spotfire Business Author and Consumer), you must configure your Web Player services to access SharePoint through your own registered application in Microsoft Azure. The details of this configuration are provided in this article:

https://docs.tibco.com/pub/sfire-analyst/14.0.5/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connectors%2Fsharepoint%2Fsharepoint_accessing_data_from_sharepoint.htm

After all configuration tasks have been completed, it's possible that loading SharePoint data in Web Player might fail with the following error:

AADSTS65001: The user or administrator has not consented to use the application with ID 'xxxx-xxxxx-xxxx-xxx'. Send an interactive authorization request for this user and resource.

This error is caused if the "Sites.Read.All" permission from the Microsoft Graph API category is missing for the application created in Azure. 
 
Resolution:

The following steps should resolve this issue:

1. Login to your Azure Portal - https://portal.azure.com/.

2. Open your Spotfire application settings page.
3. Go to API Permissions page and click on "Add a Permission" button.
4. Select Microsoft Graph API and choose Delegated Permissions as the permission type:

5. Search for "Sites.Read.All" then check this item and click on Add Permissions to add: