Forum Discussion
Solved
SharePoint List - do not return ALL columns from initial query?
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...
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-rest-requests
Regards,
Lydia
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-rest-requests
Regards,
Lydia
Thanks, testing that out now.