Forum Discussion
Limiting data pulled into PBI desktop from Sharepoint list
Super UserWolf053 ,true, so what you can do is that in power query click on the date column and click on filter and filter to show after a specific date like 1/1/2021, so the imported data to power bi will be filtered to get data after this date.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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
Wolf053 ,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 👍