Connecting to a share point folder

[Anonymous]

So I have a folder within sharepoint I want to access. (It has two excel documents inside that I want to seemlessly connect with power bi ) However when I go to get data--> sharepoint folder--> and paste the sire url I get the following messege. 

Any help would be greatly appreciated. 

[Stachu]

are you putting the whole folder path in the connection?

in general you connect to specific to a specific SharePoint site first, and then filter for a specific folder

e.g. 

company.sharepoint.com/sites/sitename/

and then filter for a specific folder in the path column

[Anonymous]

I can connect to the share point site, but what do you mean by saying to "filter for a specific folder in the path column"

Thanks

[Stachu · Accepted solution]

basically as described here:

https://community.powerbi.com/t5/Desktop/Sharepoint-Folder/m-p/240225/highlight/true#M106688

@v-yulgu-msft wrote:

Now that we’re in, we’ll be able to see all of the files from all of the folders that we have access to in that specific site. This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!