Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tjordaske85
Frequent Visitor

How to extract all files from a sharepoint library

In a library you can export all content to Excel. This creates a iqy file which can be opened in Excel. Result is a list of all folders and all files (also the ones into folders).

Tjordaske85_0-1652944148668.png

I'm trying to eliminate Excel and get all content directly into Power BI. I get to the point where I have an overview of the first 'level' in Power BI (so all folders and files when you open the library) but not all subfolders and subfiles.

Excel vs Power BI.jpg
 

Can someone points me to the right direction?

 

 

 

1 ACCEPTED SOLUTION

There is a more extensive method that can help you extract some metadata.

 

You can create a new source of a Sharepoint list and extract the documents table.

 

jcalheir_0-1653039821899.png

 

There you can extract a lot of metadata if you start expanding some fields.

Give it a try to the Folder Column and expand the record.

 

jcalheir_2-1653039941513.png

 

View solution in original post

4 REPLIES 4
Tjordaske85
Frequent Visitor

Hi @jcalheir, when expanding the Folder Column I cannot find any column that refers to our own customized added metadata

jcalheir
Solution Supplier
Solution Supplier

Hi

 

You can use the Sharepoint connector to import a full sharepoint folder in powerquery then filter only the files you want to work with. 

 

jcalheir_1-1652949693402.png

 

 

For further details in the method, please lookup this microsoft article.

https://powerbi.microsoft.com/pt-pt/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

Hi Jcalheir,

 

Thanks! This is helping me further, but using this method I cannot extract the metadata that's been added to the documents. Any idea how to add this as well?

There is a more extensive method that can help you extract some metadata.

 

You can create a new source of a Sharepoint list and extract the documents table.

 

jcalheir_0-1653039821899.png

 

There you can extract a lot of metadata if you start expanding some fields.

Give it a try to the Folder Column and expand the record.

 

jcalheir_2-1653039941513.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors