Unnesting a SharePoint document library to create a list

[AspiringAnalyst]

Hello all, I was wondering if it were possible to unnest a document library in SharePoint.  

I'd like all the documents in the "Shared Documents" > "Quality" > "Procedure Documents" folder to be listed as a table in Power BI as text objects.  The "Procedure Documents" folder has around 150 Word documents in varying stages of nesting within it, and I'm wondering if this is possible without completely rebuilding our SharePoint document structure. 

Any help would be appreciated.  I can give more information as needed, though the jist of it is that I want all the word doc titles, not the folder names, in a single list.  

[v-zhouwen-msft · Accepted solution]

Hi @AspiringAnalyst ,

Perhaps you can select the Share Point Folder in the data source of Powe BI Desktop.File information will be displayed about all files in that SharePoint folder. In addition, file information will be displayed about any files in any subfolders.You can then delete irrelevant columns in Power Query.

Power Query SharePoint folder connector - Power Query | Microsoft Learn