Azure Senitment Analysis

[John_DeKock]

Hi all, 

When using Azure AI functions in Desktop, im creating a column to score sentiment. Works great in desktop all is well.....but when I publish it....it doesnt want to show the visual...

But as soon as publish it to service.....

I have no idea what to do?

Anyone have any ideas?

TYIA

[DataChant]

Queries with AI Insights will stop refreshing on September, 15, 2025. If you want to keep the AI Insights logic inside Power Query, read my blog post here, to learn your options and how to solve it.

The article demonstrates how to implement sentiment analysis using the new Azure AI Language service, and includes a reusable M function and example solution PBIX file for further learning.

[v-sdhruv]

Hi @John_DeKock ,
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[v-sdhruv]

Hi @John_DeKock ,
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[v-sdhruv]

Hi @John_DeKock ,
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[v-sdhruv · Accepted solution]

Hi @John_DeKock ,
Seems like you have used Premium capacity for AI insights.
This might help you understand further-
https://community.fabric.microsoft.com/t5/Service/Advanced-AI-in-Premium-per-Capacity/m-p/4213040
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[John_DeKock]

Funny thing I saw now......Even though we have a F64 capacity

[v-sdhruv]

Then I would urge you go through any other limitations that might cause this issue.
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-ai-insights
You can even raise a Support ticket

To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.
Thank you for being a part of Microsoft Fabric Community Forum!

[John_DeKock]

Nope, just a simple Excel file we use for this POC, so not even a complex data source 

[v-sdhruv]

Hi @John_DeKock ,

I can understand the frustration that it doesnt show in Service but is working on Desktop.
Is your Model Direct Query? Because apparently Direct Query isnt supported.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-ai-insights

If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[John_DeKock]

thanks for this, but the workspace is indeed Premium...so it baffles me a bit

[v-sdhruv]

Hi @John_DeKock ,
Reports with applied Text Analytics and Vision functions should be published to a workspace that is on a Premium capacity, otherwise refreshing the semantic model fails. 
Please refer this for more details.

Please refer this more details-
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-ai-insights
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!