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?