Forum Discussion

agoldberg's avatar
agoldberg
New Member
9 months ago
Solved

Expression.Error: The import AIFunctions.PostProcess matches no exports. Did you miss a module refer

a premium capacity report i last used in september 2025 is now throwing me errors in the 2 sections for extract key phrases and score sentiment.

 

the error thrown for this M code:

= AIFunctions.Contents(){[Key = "CognitiveServices.ExtractKeyPhrasestexttext"]}[Data]

error:

An error occurred in the ‘’ query. Expression.Error: The name 'AIFunctions.Contents' wasn't recognized. Make sure it's spelled correctly.

 

the error thrown for this M code:

= AIFunctions.Contents(){[Key = "CognitiveServices.ScoreSentimenttexttext"]}[Data]

error:

An error occurred in the ‘’ query. Expression.Error: The name 'AIFunctions.Contents' wasn't recognized. Make sure it's spelled correctly.

 

 

in the query with the step for "applied extract key phrases" where it looks like this:

= AIFunctions.PostProcess(Table.AddColumn(#"Sorted Rows", "Extract key phrases", each #"Extract key phrases"([Response], null)), "Extract key phrases", "CognitiveServices.ExtractKeyPhrasestexttext") meta [FunctionBrowser="TextAnalytics"]

error:

Expression.Error: The name 'AIFunctions.PostProcess' wasn't recognized. Make sure it's spelled correctly.

 

 

our power bi reports that have been working for several years should not be all of a suddent broken and unfixable. ive never seen this happen. help?

  • Hi agoldberg 

     

     This is AI generated and unverified, but I hope it helps:

     

     Your issue is happening because Microsoft retired Cognitive Services and Azure Machine Learning integration in Power BI as part of the transition to Microsoft Fabric AI services. This retirement was completed on September 15, 2025, and all related features (including AI Insights like Extract Key Phrases and Score Sentiment) were removed from Power BI Desktop and Service.

    Here’s what changed and why your M code is failing:

    What Happened

    • AIFunctions.PostProcess and AIFunctions.Contents were part of the old AI Insights connector that relied on Cognitive Services.
    • Microsoft announced that starting August 11, 2025, you could no longer create new models using these services, and by September 15, 2025, refresh support for existing models ended. After that date, the functions were completely removed from Power BI. [m365admin....sontek.net], [powerbi.mi...rosoft.com], [datachant.com]

    Why Your Reports Broke

    • Any query steps using AIFunctions.PostProcess or AIFunctions.Contents now throw Expression.Error because those functions no longer exist in the Power Query engine.
    • This affects both Premium capacity and Pro users—the retirement was global.

    🔄What You Can Do

    Microsoft recommends migrating to Fabric AI services or Azure AI REST APIs. Here are your options:

    1. Move to Microsoft Fabric AutoML or AI Services

      • Use Synapse Data Science in Fabric for AutoML workflows.
      • For text analytics (sentiment, key phrases), use Azure AI Language integrated with Fabric. [datachant.com]
    2. Call Azure AI REST APIs from Power Query

      • Replace the old M code with custom calls to Azure Cognitive Services endpoints.
      • Example approach:
        • Use Web.Contents() in M to call the Azure Text Analytics API.
        • Parse the JSON response and extract sentiment or key phrases.
      • This keeps the logic inside Power Query without moving to Fabric immediately.
    3. Short-Term Workaround

      • If migration to Fabric is not possible yet, you can implement sentiment analysis and key phrase extraction using:
        • Azure AI Language REST API
        • Or Python/R scripts in Power BI (requires enabling scripting).

    --------------------------------

    I hope this helps, please give kudos and mark as solved if it does!

     

    Connect with me on LinkedIn.

    Subscribe to my YouTube channel for Fabric/Power Platform related content!

4 Replies

  • Hi agoldberg 

     

     This is AI generated and unverified, but I hope it helps:

     

     Your issue is happening because Microsoft retired Cognitive Services and Azure Machine Learning integration in Power BI as part of the transition to Microsoft Fabric AI services. This retirement was completed on September 15, 2025, and all related features (including AI Insights like Extract Key Phrases and Score Sentiment) were removed from Power BI Desktop and Service.

    Here’s what changed and why your M code is failing:

    What Happened

    • AIFunctions.PostProcess and AIFunctions.Contents were part of the old AI Insights connector that relied on Cognitive Services.
    • Microsoft announced that starting August 11, 2025, you could no longer create new models using these services, and by September 15, 2025, refresh support for existing models ended. After that date, the functions were completely removed from Power BI. [m365admin....sontek.net], [powerbi.mi...rosoft.com], [datachant.com]

    Why Your Reports Broke

    • Any query steps using AIFunctions.PostProcess or AIFunctions.Contents now throw Expression.Error because those functions no longer exist in the Power Query engine.
    • This affects both Premium capacity and Pro users—the retirement was global.

    🔄What You Can Do

    Microsoft recommends migrating to Fabric AI services or Azure AI REST APIs. Here are your options:

    1. Move to Microsoft Fabric AutoML or AI Services

      • Use Synapse Data Science in Fabric for AutoML workflows.
      • For text analytics (sentiment, key phrases), use Azure AI Language integrated with Fabric. [datachant.com]
    2. Call Azure AI REST APIs from Power Query

      • Replace the old M code with custom calls to Azure Cognitive Services endpoints.
      • Example approach:
        • Use Web.Contents() in M to call the Azure Text Analytics API.
        • Parse the JSON response and extract sentiment or key phrases.
      • This keeps the logic inside Power Query without moving to Fabric immediately.
    3. Short-Term Workaround

      • If migration to Fabric is not possible yet, you can implement sentiment analysis and key phrase extraction using:
        • Azure AI Language REST API
        • Or Python/R scripts in Power BI (requires enabling scripting).

    --------------------------------

    I hope this helps, please give kudos and mark as solved if it does!

     

    Connect with me on LinkedIn.

    Subscribe to my YouTube channel for Fabric/Power Platform related content!

    • v-priyankata's avatar
      v-priyankata
      Community Support

      Hi agoldberg 

      Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

       

      • v-priyankata's avatar
        v-priyankata
        Community Support

        Hi agoldberg 

        I wanted to check if you had the opportunity to review the information provided by users. Please feel free to contact us if you have any further questions.