Forum Discussion
Limiting data pulled into PBI desktop from Sharepoint list
Hi all, new to PBI and have a quick question which I am hoping has a relatively simple solution.... Is there a way to limit the amount of records initially pulled into PBI from each SharePoint lis...
Idrissshatila , thanks for this - so would this mean when hitting refresh, only records that fall within the filter parameters are pulled and refreshed? Or will PBI still refresh by pulling all rows from SharePoint first, then filtering from there?
Idrissshatila
Super User
Super UserWolf053 ,when refresh, power bi pulls all the data to power query and then filters to import only the data that falls in the filter.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila That makes sense - is there a way to not initially pull all the data into power query prior to filtering?
- Idrissshatila
Wolf053, Then it should be in the datasource.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍