SharePoint List - do not return ALL columns from initial query?

[OneWithQuestion]

I am connecting to an SPO list, works great!

Using:

let
    Source = SharePoint.Tables("https://chenega.sharepoint.com/it", [ApiVersion = 15]),

The question I have is this list has 150 rows but is over 4.5 MB in size.

It does have attachments in it, etc, etc... as it is actually a document library.

Is there anyway when I am specifying my data source where I can specify which columns from the list I want or fields?

For example, once I return the data I go into the editor and remove a bunch of columns that are pointing to tables and drill down records.

However, it seems it still returns all that data on the initial data pull?

For example, I specify to remove these columns, but it seems it returns them all first then later removes them:

*Also AttachmentFiles, etc, etc...

[v-yuezhe-msft · Accepted solution]

@OneWithQuestion,

You can the OData feed connector in Power BI Desktop and use the following URL to specify fields.

https://yoursharepointsite/_vti_bin/listdata.svc/ListName?$select=column1,Column2,column3

Reference:
https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-...

Regards,
Lydia

[OneWithQuestion]

Thanks, testing that out now.