Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
52 | |
21 | |
12 | |
11 |