Solved: Text Analytics - AI Function

AT2812 · ‎08-17-2020

Hello team,

I am using Text Analytics AI function built in power query for doing analysis against the unstructured text. On loading the data into the report builder from power query after applying some transformation steps and "Extract Key Phrase" from AI function against this unstructured text column, it's taking lot of the time to render the data. Earlier I was working with some 60K rows of unstructured text and then I reduced it to 2-3K rows... but still, it's doesn't load the information quickly into the report builder.

This is what I get...

Can you please help with this issue as I need to present the analysis to my leaders.

Ashish

Anonymous · ‎08-18-2020

HI @AT2812,

Any advanced operation in your query table steps? (e.g. merge, combine, reference, custom functions...)
If this is a case, they may cause the duplicate resource and memory speed on these calculations. I'd like to suggest you refer to following link to add buffer functions to reduce the processing spend on these operations.

How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng

View solution in original post

Anonymous · ‎08-18-2020

HI @AT2812,

Any advanced operation in your query table steps? (e.g. merge, combine, reference, custom functions...)
If this is a case, they may cause the duplicate resource and memory speed on these calculations. I'd like to suggest you refer to following link to add buffer functions to reduce the processing spend on these operations.

How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng