Cognitive services "key phrase extraction" changes other columns

[leo85]

I want to analyse a set of messages and replies in Power BI.

I have a set of messages and replies, which are connected by message IDs. Next to the message ID and text, there are many other columns like date, time, users, etc.

I'm trying to do a key phrase extraction with Azure Cognitive Services. Via the Text Analysis feature in Power Query this works fine, but when I do that many of the other columns are changed.

There is an error, when applying the changes, because all of the message IDs are changed to the same ID.

Does anybody have the same problem or know how to deal with it?

[leo85 · Accepted solution]

I found the problem. In the end it was my mistake for not understanding the Text Analysis feature enough and there was no problem.

The Text Analysis feature does not only add a column with a comma-separated list of key phrases, but also adds a row for every single keyphrase.So there were hundreds of new rows, which I did not realize were mostly the same.

[v-yingjl]

Hi @leo85 ,

Could not reproduce it in my side. Maybe you can refer this viedo about Cognitive services in power query:

1. Text Analysis in Power BI with Cognitive services 
2. Tutorial: Integrate Power BI with the Text Analytics Cognitive Service 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.