Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to 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,
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
Thanks, testing that out now.