Where can i find the list of columns when i get data from Sharepoint online list

[Anonymous]

Hi All,

I was able to connect to the Sharepoint site by using the connector Sharepoint Online List. When i loaded the data according to some documents the column type should be binary but it showing NULL can someone please advice. Please see the attached screen shot. I want to load th data from the .xlsx file.

[Icey · Accepted solution]

Hi @Anonymous ,

There are two workarounds. Please check:

#Ⅰ  Use "SharePoint Folder" connector like what @mahoneypat mentioned.

1. Connect to the online SharePoint site.

2. Click "Transform Data".

3. Filter "Folder Path" column to specify one or more document libraries if needed.

4. Filter "Extension" column to specify one or more file types.

5. Combine files.

6. Choose the first file and click OK.

7. Expand "Data" column to get file data.

#Ⅱ  Create a blank query and use "SharePoint.Contents" function like what @jairoaol mentioned.

1. Create a blank query.

2. Paste this:

let
    Source = SharePoint.Contents("https://xxx.sharepoint.com/sites/xxx/")
in
    Source

3. Choose the table you needed in "Content" column.

4. Repeat step 4 to step 7 of workaround #Ⅰ.

Best Regards,

Icey

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

[Syndicate_Admin]

switches to SharePoint.Contents this first part of the M code

Source = SharePoint.Tables("https://comos.sharepoint.com/sites/PowerBI/", [Implementation="2.0", ViewMode="Default"]),

[mahoneypat]

If you are looking to connect to files, you should use the SharePoint Folder connector, not the list one.  You can switch to that connector or change your Source line to use SharePoint.Files or SharePoint.Contents, instead of SharePoint.Tables.

Pat

[Anonymous]

@mahoneypat thanks . This is not our network , it is an online sharepoint site.

Thanks

[AlexisOlson]

The problem is still the same. You are trying to use a SharePoint list connector to connect to a SharePoint file. If you want to connect to a SharePoint file, you must use the appropriate (different) connector, as @mahoneypat pointed out.

[AlexisOlson]

What does your query M code look like?

[Anonymous]

@AlexisOlson thanks

let
    Source = SharePoint.Tables("https://comos.sharepoint.com/sites/PowerBI/", [Implementation="2.0", ViewMode="Default"]),
    #"cd5eed38-9a7a-441c-b706-aa952a8aef2d" = Source{[Id="cd5eed38-9a7a-441c-b706-aa952a8aef2d"]}[Items],
    #"Sorted Rows" = Table.Sort(#"cd5eed38-9a7a-441c-b706-aa952a8aef2d",{{"Modified", Order.Descending}})
in
    #"Sorted Rows"