Apply query changes taking very long time for text analysis

[Anonymous]

Hi, 
I have the data source Excel.  and I want to apply the keyphrase on the column so I did the below steps
1. duplicate the main table 
2. Removed unnecessary columns 
3. filtered Null, Blank, and non-text from column
4. Applied language detection 
5. Applied keyphrase 
And Everything works fine in the power query but when I close and apply the changes it keeps spinning. 
But when I remove step no 4 and 5 then it takes only a few sec to apply the changes. 
Am I missing something or is there any limitation with the text analysis?

[selimovd]

Hey @Anonymous ,

did you in the Text Analytics chose a premium or premium per user capacity?:

Otherwise it will only use the general available capacity. Depending on availability and the amount of your data this can take a while since it's a shared resource with the rest of the world.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Hi @selimovd 

Thanks for your reply, I had selected the premium capacity but then also it's taking too long and keep spinning.