Forum Discussion

leo85's avatar
leo85
New Member
5 years ago
Solved

Cognitive services "key phrase extraction" changes other columns

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?

 

Need Help
  • leo85's avatar
    leo85
    5 years ago

    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.

2 Replies

  • leo85's avatar
    leo85
    New Member
    5 years ago

    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.