...
If a user is logged in to both Confluence and SharePoint, then the SharePoint List macro or SharePoint Document macro in Confluence will only display lists and documents the logged in SharePoint user is permitted to see in SharePoint itself.
Especially for a document library where the logged in SharePoint user has only access to some (but not all) files respectively folders: In this case the SharePoint List macro will also only display these files respectively folders.
User logged in without permission
...