Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Apply query changes taking very long time for text analysis

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?

Interesting Links
Need Help
Tips and Tricks

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    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
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi selimovd 

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