Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
DataGeometry
Regular Visitor

Transform data by directquery

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.

1 ACCEPTED SOLUTION
v-yingjl
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
v-yingjl
Community Support
Community Support

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
Resident Rockstar
Resident Rockstar

@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
Resident Rockstar
Resident Rockstar

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?

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors