Azure Text Analytics Slow Load Time

[AlexM1989]

Hi All,

I've recently been using Azure Key Phrases analysis on some data sets, but I notice that when the data sets get sufficiently large, the load time when saving and loading in Power Query is taking forever.

For example, I used a free test dataset of around 60,000 job postings and ran the key phrase analysis on each row of job description, however when I close and load to the visualisation area the window which says "connecting to XXXXX.azurecognitiveservices.com" only shows progress of maybe 100 records every 60 seconds, which is extremely slow.

I am only running a free Azure account for the moment, however is this something that can be sped up with premium pricing tiers? Or is this an issue at the PowerBI platform as opposed to Azure? Hoping someone can help.

Thank you!

Alex

[Anonymous · Accepted solution]

Hi @AlexM1989 ,

You can refer the following blog to connect Azure Text Analytics in Power BI Desktop.

How To Use Azure Text Analytics In Power BI

And please try to uncheck background data (File –> Options –>Data Load –>Allow data previews to download in the background) and check whether it can reduce the load time of data:

Any way to speed up really slow refresh times in Power Query?

Best Regards