SharePoint list filtering

geay · ‎11-19-2017

In Power BI, I want to connect to a SharePoint list and filter the data that is imported.

I need the filter to be applied before the data is imported. The list has about 20,000 records and I only need about 200 items filtered by content type.

I have connected to the SharePoint list and then applied a filter on the column. Does this filter import the results before or after importing the data?

Anonymous · ‎11-20-2017

HI @geay,

Current power bi sharepoint connector not contains any filter features. In my opinion, I'd like to suggest you to use OData connector to instead.(Sharepoint REST API) You can add conditions to query string to filter records before import data.

Reference:

Working with lists and list items with REST

URL Conventions (OData Version 3.0)

Regards,

Xiaoxin Sheng