Columns missing when connecting to nested MS Teams folder

[hawke]

I am connecting to an MS Teams Channel where the documents folder has numerous layers of nested subfolders. The files I need are buried several levels down. Additionally, some columns have been added to the Document folder where the user manually enters metadata. I need to connect to several of the nested subfolders and pull in the data from ALL columns.

When I connect using the SharePoint Folder connector, I'm able to drill-down to the nested folders that I need, however, only the data from the standard columns pulls in to Power BI (Content, Name, Expension, Date Accessed, Date modified, Date Created, Attributes, and Folder Path). None of the added columns are included. The Attributes column is the only one that can be expanded,  and it only has options to add columns for Size, Content Type, and Kind, which are not the columns I am missing. 

When I connect using the SharePoint Online List connector, all of the missing columns appear, but I am not able to drill-down on the Documents folder beyond the first-level subfolder. There are options to expand several columns and I've tried expanding every one them and nothing allows me to drill down to the lower level nested subfolders.

Any ideas how I can get this work?

[hawke · Accepted solution]

I was able to use the steps outlined in this video and was able to modify it to work for my needs https://www.youtube.com/watch?v=RuQwIr9XXMM&t=379s

[v-priyankata]

Hi @hawke 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[hawke]

I have not resolved the issue yet. Still looking for a solution.

[Akash_Varuna]

Hi @hawke You can use the SharePoint API with Power Query’s Web connector to retrieve all custom columns and nested folder metadata. Or could you try to combine the SharePoint Online List connector for metadata and the SharePoint Folder connector for nested folder structure, merging them in Power Query. Writing a custom M query can also help traverse the folder structure while pulling all columns. Power Automate is another option to extract metadata and save it for Power BI access.