Textfilter in Power Query do not work randomly

[BettinaO]

I have the problem from time to time that simple text filters in Power Query do not work. Just to be clear: I work a lot with PowerBI and usually it works as intended, but now I have a file where I'm not able to text-filter any of the tables and I have experienced this behavior before.
No error, everything looks fine, but the data just won't be filterd. Sometimes it works if I try again a few days later.

Has anyone else experienced this behaviour? Any idea how to solve this?

[jaweher899]

This behavior can be caused by a number of factors, including data source issues, data type mismatches, incorrect filter syntax, and more. Here are some steps you can try to resolve the issue:

1. Check data types: Make sure the column you're trying to filter is of the text data type. If not, change the data type.

2. Verify the filter syntax: Make sure the filter syntax is correct.

3. Refresh data source: Try refreshing the data source and see if it resolves the issue.

4. Remove and re-add the filter: Remove the filter and then add it back again to see if that fixes the issue.

5. Restart Power Query: Close Power Query and then open it again to see if that fixes the issue.

6. Try filtering a smaller subset of the data: If the data source is large, try filtering a smaller subset of the data to see if that resolves the issue.

7. Try using a different method of filtering: If the text filter is not working, try using a different method of filtering such as a conditional column.

If none of these steps resolve the issue, you may need to troubleshoot further by reviewing the data source, logs, and so on.

[BettinaO · Accepted solution]

I have found a way to solve the Problem:

It works if you set the datatype to text manually (even if the datatype which was automatically set already is text! (as you see in the screenshot above)). This seems to make a difference.

[Anonymous]

Thank you Bettina, your solution just worked for me too. Even though the column was of a number type, it just wouldn't filter zero. Once I manually  set type to number - worked .

Must be a bug

Thank you