Authetication Sharepoint datasource even without access to root directory

Sometimes, people are not granted access to the root directory or the folder in SharePoint. They are only provided access to specific files, for instance, an Excel file. I suggest a way that lets pe...