AI Services in Power Query

[zar1]

Within Power BI Desktop, I have been accessing AI Insights in Power Query to perform text analytics (sentiment analyis, language detection, key phrase extraction). I would invoke text analytics options by clicking on the "Add Column" tab and then clicking on the "Text Analytics" button as shown in the screen capture below. Unfortunately, the AI insights "buttons", text analytics, vision, and Azure machine learning are no longer visible in Power Query. It's not a matter of them being greyed out (which would suggest they are not supported by my license) -- rather, the buttons are no longer there. I tried across two different computers that have Power BI on them but the same issue exists. Power BI Desktop is updated to latest version, all preview features are enabled, and I am working with a PPU license. The features were there one day and then simply "gone" the next time I tried to use them. I have been unable to find reports of the same issue by others. What might be happening here/what am I missing? 

Thanks for any insight you can offer!

[v-pnaroju-msft]

Thankyou, @OwenAuger, for your response.

Hi zar1,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solution provided by @OwenAugerto resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[OwenAuger]

Hi @zar1 

From what I can glean, unfortunately this feature is being retired:

https://powerbi.microsoft.com/en-us/blog/cognitive-services-and-azure-ml-for-dataflows-will-be-fully...

I assume that's why the AI Insights section has been removed from the interface.

I also see that the AI Insights documentation page no longer exists (https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-ai-insights) but you can view an archived version here.

I tried installing an older version of Power BI Desktop (January 2025) and the AI Insights options are present, but no functions are available in the dialog box after selecting one of the options (Text Analytics example below).

Out of interest, are you able to refresh existing models using any of these functions or copy and reuse Power Query code from an existing query? From the blog post, it sounds like this might work for another month.

Power BI Desktop 2.139.2054.0 64-bit (January 2025)