Forum Discussion
wskallmeyer
Advocate II
Advocate IIUnexpected results for data source SharePoint 2013 List items using a SharePoint REST API
I am trying to pull items/properties from a SharePoint 2013 List using a REST API call. I cannot use the Power BI built in data source because over 8 GB of data is getting returned because of PDFs b...
You shouldn't be using REST, you should use OData. If you set your filters in Power Query as shown in this link, https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/ they will be automatically added to the OData call and filtered out. The process for SharePoint 2013-2019 and Office 365 are the same.
Hope this helps!
--Treb, Power BI MVP
trebgatte
Most Valuable Professional
Most Valuable ProfessionalYou shouldn't be using REST, you should use OData. If you set your filters in Power Query as shown in this link, https://marqueeinsights.com/how-to-data-mine-a-sharepoint-list-with-power-bi/ they will be automatically added to the OData call and filtered out. The process for SharePoint 2013-2019 and Office 365 are the same.
Hope this helps!
--Treb, Power BI MVP