Sharepoint Connectors Showing Metadata but Authentication Error on accessing files

Hi all,   As below, some Sharepoint sites in the org have started throwing this error in the last couple of weeks. The error appears in both Gen1 and Gen2 dataflows, with the same level of permissi...