Filter Shaepoint list in Powerpivot

[dileeprajam]

I am trying to import the data from SharePoint into my PowerPivot window as a Datafeed. I am able to successfully import the whole data from SharePoint list. But, now i would like to apply a filter (Where Clause) before importing the data.

Can anyone help me in this.

Thanks,
-Dileep

 

[scottsen]

I haven't done this myself, but a google on "sharepoint listdata.svc filter" certainly implies it is doable. If not.. you could probably fall back to Power Query to do the filtering?