Sharepoint Library - Importing sub folder

[jcastr02]

I have a sharepoint library that I am trying to get imported to BI - but some of the columns are not pulling over.  I read online that when importing you import as a list and then replace in advance editor to "sharepoint.contents."  However, still not seeing some of the columns pull over.  Example in the sub folder Pharmacy care center, I can't see the source column.  Any ideas?  See image attached and query steps below.

let
Source = SharePoint.Contents("https://walgreens.sharepoint.com/teams/W_RxHW7/Apollo/", [ApiVersion = 15]),
#"Added Custom" = Table.AddColumn(Source, "URL", each [Folder Path]&[Name]),
#"Shared Documents" = #"Added Custom"{[Name="Shared Documents"]}[Content],
Procedures = #"Shared Documents"{[Name="Procedures"]}[Content],
#"Pharmacy Care Center" = Procedures{[Name="Pharmacy Care Center"]}[Content],
#"Expanded Attributes" = Table.ExpandRecordColumn(#"Pharmacy Care Center", "Attributes", {"Size", "Content Type", "Kind"}, {"Attributes.Size", "Attributes.Content Type", "Attributes.Kind"})
in
#"Expanded Attributes"

[v-kkf-msft]

Hi @jcastr02 ,

Because the "Source" column is a custom column, please try using SharePoint Online List.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[jcastr02]

Hello @v-kkf-msft  I tried to import that way but get below error message.  Even to get somewhat of an import I updated the advance editor query steps to "shared contents" but can't get to subfolder.  See Image - any help would be appreciated.

[v-kkf-msft]

Hi @jcastr02 ,

I haven't reproduced your issue. Please delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect to see if it works.

Best Regards,
Winniz