Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a column that contains comments posted by different groups of people. Below image for reference.
I want to extract specific words from the comments, and then use that extracted columns as a category filter.
Solved! Go to Solution.
HI @AbbasG ,
I suggest two approaches.
1) In Power Query, you can use Cognitive Services to automatically extract keywords (Tutorial: Integrate Power BI with key phrase extraction - Azure Cognitive Services | Microsoft Learn)
2) Use Power Query function like this example (Searching for Text Strings in Power Query • My Online Training Hub)
Marco
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
@menglaro78 Hi thanks for the reply, it works but a bit difficult to set-up instead I managed it in SQL database through query.
HI @AbbasG ,
I suggest two approaches.
1) In Power Query, you can use Cognitive Services to automatically extract keywords (Tutorial: Integrate Power BI with key phrase extraction - Azure Cognitive Services | Microsoft Learn)
2) Use Power Query function like this example (Searching for Text Strings in Power Query • My Online Training Hub)
Marco
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!