Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I never seen this before. Usually, power query is bulletproof. Choose a column, filter what you want and bingo, that's what you get.
Below is a screenshot of a table where I am excluding a value from table to be returned. Yet, the table returns with the value still present. Why?
Solved! Go to Solution.
Experiment with the "Text Filters" options, e.g. "begins with...." and "does not begin with".
Also I suggest using Trim and/or Clean from the Transform menu to get to the bottom of this.
There could be a space or hidden character in there. Did you type the line of code or did you use the 'Text Filters' from the column dropdown?
I used both the items from the drop-down list and manually entering it into the M code.
Experiment with the "Text Filters" options, e.g. "begins with...." and "does not begin with".
Also I suggest using Trim and/or Clean from the Transform menu to get to the bottom of this.
Using begins with or contains resulted in the same issue. However, using either Clean or Trim or both fixed the issue.
Glad you got it sorted. Every similar case I've seen has a space or a hidden character.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.