Transform data by directquery

[DataGeometry]

Hello, I am trying to use the text analyzer of a streaming in real time, however, when doing this in a DirectQuery way, it throws me an error, I wanted to know if there is a solution to represent the text analysis in real time, thanks.

[v-yingjl · Accepted solution]

Hi @DataGeometry ,

If the 'text analyzer' represents 'Text Analytics' feature in Power Query, please see:

There are a few considerations and limitations to keep in mind when using Text Analytics.

• Incremental refresh is supported but can cause performance issues when used on queries with AI insights.
• Direct Query is not supported. 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Daryl-Lynch-Bzy]

@DataGeometry  - can you please:

1. share example of the You Tube video that you have watched
2. provide a screenshot of the error message
3. provide an example of the data and result you want from that data

[Daryl-Lynch-Bzy]

Hi @DataGeometry - I am not familiar with "text analyzer of a streaming".  can you provide more information or screenshots show what you are trying to do?

[DataGeometry]

Hello

I'm trying to use the powerbi text analyzer to review some live streaming comments from youtube. I've an issue when I'm connecting the data source through direct query, this doesn't allow me make transformations.

thanks