Forum Discussion
Filter does not work
Hi there
I wanted to set a filter on a column in PBI Deskto (editing queries). The text filter is set on the content of the field (subject text contains "client").
= Table.SelectRows(#"Inserted Days", each Text.Contains([Subject], "client"))
There has been 1 prepared record for tests which contained this text "client" and 12 others, out of thousands. The prepared record is shown in the preview correctly, togheter with others. Totally 13 rows are displayed.
So far no problem, but:
As soon as I click on "Close & Apply", PBI Desktop only shows 12 rows, and excactly my testing record dissapeared.
Does someone know what happened here?
Thanks for any hint!
Patrick
This is tough without being able to see the query but my thoughts are ...
1) are there other steps in the query that could be hiding the row?
2) is the word "client" all in lowercase - PQ is case sensitive
3) how did your test row make it into the dataset? is it from the same data source as the other data?
4) finally, i've noticed that sometimes the query preview feature doesn't work exactly right - that could be what you're dealing with
Here the screenshots for easier understanding of how preview is ignoring case sensitive text filter and for those might having the same issue.
Filter by lower case "client reponse" will find the test data record with text "Client Reponse" in Query Editor preview...
...but not as a result:
Filtering by upper case "Client Reponse" will find the test data record in Query Editor preview.
...and also the data record, as the filter is case sensitive. But this is ignored by the preview...
Best regards
Patrick
7 Replies
This is tough without being able to see the query but my thoughts are ...
1) are there other steps in the query that could be hiding the row?
2) is the word "client" all in lowercase - PQ is case sensitive
3) how did your test row make it into the dataset? is it from the same data source as the other data?
4) finally, i've noticed that sometimes the query preview feature doesn't work exactly right - that could be what you're dealing with
Hi Austin
Thank you! Your 2nd point just guided me to the answer - which seems to be a bug in the preview. The filter in Query Editor is not case sensitive, but PQ is... I'll send a fraun to MS.
Btw: The data is loaded from our on-premise CRM Test system, the data source is the same for all records.
Here the screenshots for easier understanding of how preview is ignoring case sensitive text filter and for those might having the same issue.
Filter by lower case "client reponse" will find the test data record with text "Client Reponse" in Query Editor preview...
...but not as a result:
Filtering by upper case "Client Reponse" will find the test data record in Query Editor preview.
...and also the data record, as the filter is case sensitive. But this is ignored by the preview...
Best regards
Patrick