Unstructured text search/analysis in Q&A

[solcelle]

This idea is to add unstructured text search/analysis to the Q&A module in PowerBI. This will enable users to search for keywords and/or phrases in the text column through the Q&A search field, so that I could do more advanced filtering on non-numeric data. If the dataset contains a column with unstructured text (e.g. DescriptionText), I want to search for and/or filter on keywords in this column. Sample value for DescriptionText column: "Conceptual study for California solar power plant 2013". I want to use PowerBI Q&A to search for (and count) items that contain California in the DescriptionText column. This is similar to facets works in search engines. Example query: COUNT Items WHERE DescriptionText CONTAINS California AND "solar power" AND 2013 Ref.1) Community discussion thread: http://community.powerbi.com/t5/Service/Unstructured-text-search-in-Power-BI-Q-amp-A/m-p/11203#M4314 Ref.2) Faceted search in Apache Solr: http://lucidworks.com/blog/2009/09/02/faceted-search-with-solr/

[anthony_vandenb]

great idea

[kris_ruyeras]

Wonder if this have been implemented yet on the latest release? This is huge as it would eliminate the need of creating PHP search engine within internal data for descriptiontext.

[peyg]

Please MS - this is a bloody good idea!

[tuphanhuy]

The feature has been implemented. You can ask questions with filters like ... where FIELD contains/starts with "something" Note that the search string needs to be in quotes though.

[shakti_mahopatr]

Hello All , Any body has idea what's the status of implementation of this idea ? I am looking for this feature as it will help our users to search instead of exporting the table in case the row limit is huge.

[peyg]

Even if its as simple as "COUNT items where FIELD contains "Something"

[randall_talbot]

Any updates on how to search keywords in an unstructured text field?

[antiparras]

Despite working with "picklisted" fields in our data sources, several times we've got relevant and even critical data in description / comments / remarks fields. Being able to use the Q&A feature to look for tags / keywords within those fields will be highly useful and provide Power BI with a feature that some of its competitors have already integrated.

[brian59]

crickets....?

[bharat3singh199]

Is there any way to search multiple keywords in one phrase separated by "or"?