I have some folders in Sharepoint and I want to be able to connect to these in Power BI
The folders are in

Get Data

There is no specific connector to Sharepoint Document Library at present
Choose Sharepoint Folder. Add in the Sharepoint Location. The route URL is required here

You may then need to authenticate your Sharepoint connection
When you get to the next screen notice that the content that is shown are files and we don’t want this. Click Edit

Simply Remove Files and change it to Contents

Click the tick and your contents will be refreshed to show Files
In this case click on Table against the Uploads folder which takes the user down to the next level.

Here are the 3 files that I want to append with all the data
Hopefully Power BI will introduce a better way of adding in Sharepoint Document Library soon