Utilizing a shared Sharepoint Folder

Hello.   My goal is to create a dashboard that will schedule refresh without the use of a gateway. In order to this, I have been utilizing personal sharepoint files/folders for my data. Now I want ...