While using the O365 Office Sharepoint connector gives a 403 when accessing the connector.
Environment
Resolution
The workaround is giving Full control to the user of the folder where the data resides instead of All sites permission.
Cause
This is a Microsoft issue. See Setup anonymous access on a Sharepoint 2013 Online list and Access denied. Before opening files in this location.