Filter does not applied in power bi query

[amal_01]

I have a table called InventTrans, and it contains a large amount of data. I applied a filter in Power Query on the InventDate column to include only records on or after 1/1/2025. However, when I click Close & Apply, it still loads all the data from the table. It looks like the filter isn't working.

Why is this happening?

[BA_Pete]

Hi @amal_01 ,

My guess is that the source you are using is not foldable - is it SharePoint/network folder/Excel/CSV etc.?

In this case, Power Query can not send your filter back to the source to only retrieve the filtered rows, therefore, when you apply your query to the model, it has to load ALL the rows, then filter them in the model afterwards.

In order to avoid this behaviour (and only load filtered rows first time) you need to use a foldable source, such as SQL Server etc.

More detail available here:

Solved: Query Folding - Supported and Unsupported Data Sou... - Microsoft Fabric Community

Pete

[Abhilash_P]

Hi @amal_01 ,

If your data source is sql database can you below sql statement directly

SELECT *
FROM InventTrans
WHERE InventDate >= '2025-01-01'

[MFelix]

Hi @amal_01 ,

This may depend on a lot of things but I would do a couple of checks, I assume you have already done some of this but just double checking,

• Data type is correct before doing the filter in this case is date
• Be sure the format of thedate you are using in the filter is correct based on your local settings of PBI file
• Number of rows are the same before and after the filter
  • Usually I use the Count rows on the  Transform bar

• After load do a sorting of the date column to see what is the minimum and maximum value

Without any data and example is difficult to understand what may be happening