sharepoint folder and list

[EDO_01_1789]

Hello everyone,

I need your help on the connection with sharepoint.

Before I start, I'll quickly explain how my company's sharepoint looks like.

First of all in the section "Document" (see number 1 on the screenshot) we have several folders (ABCDE --> see number 2 on the screenshot). We also have several columns (see number 3 on the screenshot).

When I click on one of the folders (ABCDE --> see number 4 on the screenshot) I have a sharepoint list that appears with the same columns (see number 5 on the screenshot). In this sharepoint list I have several excel files as well as a lot of data and it is these data that I want to extract on power BI.

Unfortunately when I try the "sharepoint folder" connector in power bi it only allows me to combine the excel files and does not allow me to have the column data.

Moreover, when I try to use the "sharepoint online lists" connector I am only able to get the column data from the previous step and not the data inside the folder.

my question is if it is possible to extract the data from a sharepoint list inside a sharepoint folder.

I really need your help if you have a solution.

thanks for your help

[v-jianboli-msft · Accepted solution]

Hi @EDO_01_1789 ,

Microsoft makes getting files from folders a bit easier with their SharePoint Connector. And you'll need to get the URL of your SharePoint Library.

For more details, please refer to:

Get Excel Data from a Single File or Entire Folder on SharePoint or OneDrive for Business into Power... 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.