When connecting to the SharePoint Lists using 'Username/Password' authentication, the following error may occur:
Error Code: 4B987496
Client unable to establish connection. Unrecognized response when getting SharePoint online security cookies, please check your credentials.
SSO is used to connect to Office 365 outside of Tableau and SSO is not configured correctly in Tableau to connect to Office 365. (Username/Password is used)
Username and password cannot be used to connect to Office 365 from Tableau if SSO is used to connect to 365.
This error is a Microsoft error and if you are using SSO for Office 365 you will have to add the SSO connection to your trusted sites under your internet settings:
Sharepoint.<Company Name>.com and this will fix the issue.001472685

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.