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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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