Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
6 months ago
Solved

AI Powered Self Service Features

where can i find list of AI powered self service features in Power BI?

  • Hi powerbiexpert22,

    There isn't one single "master list" PDF, but the features are generally categorized into AI Visuals (front-end) and AI Insights (data transformation) in the Microsoft Learn documentation.

    Here is the comprehensive breakdown of the AI-powered self-service features currently available, categorized by how you apply them.

    1. AI Visuals (No Code Required)

    These are standard visualizations you can drag and drop onto your canvas.

    • Key Influencers: Analyzes your data to understand which factors drive a specific metric (e.g., "What influences Customer Churn to be 'Yes'?").

    • Decomposition Tree: Uses "AI Splits" to automatically find the highest or lowest value in the next dimension of your hierarchy.

    • Q&A (Natural Language): Allows users to ask questions in plain English (e.g., "Total sales by region") and generates a visual automatically.

    • Smart Narrative: Automatically generates text summaries and dynamic insights based on the data in your report page or specific visuals.

      2. Built-in Analytical Features (On Standard Visuals)

      These are AI features embedded into standard charts (like Line or Scatter charts) via the Analytics pane (magnifying glass icon).

      • Anomaly Detection: Automatically detects anomalies in time-series data and provides explanations.

      • Forecasting: Predicts future values based on historical trends (available in Line Charts).

      • Clustering: Automatically groups data points with similar characteristics (available in Scatter Charts).

      • "Analyze" (Quick Insights): Right-click a data point in a visual > Analyze > "Explain the increase/decrease" or "Find where this distribution is different."

        3. AI in Power Query (Data Prep)

        • Column from Examples: Uses AI to detect patterns in your input to generate complex M transformations (e.g., extracting names from email addresses) without coding.

        • Fuzzy Merge: Uses AI algorithms to join tables based on similar (but not identical) text strings.

          4. Advanced AI (Requires Premium/Fabric)

          • Copilot for Power BI: Uses Generative AI to create report pages, write DAX measures, and summarize semantic models.

          • AI Insights (Dataflows): Access to pre-trained models from Azure Cognitive Services (Sentiment Analysis, Key Phrase Extraction, Image Tagging) directly in the Power Query editor.

          • AutoML: Allows business analysts to build, train, and invoke Machine Learning models directly within Power BI dataflows.

            Where to find the official documentation:

            You can find the deep-dive technical details for these features here:

3 Replies

  • Hi powerbiexpert22,

    There isn't one single "master list" PDF, but the features are generally categorized into AI Visuals (front-end) and AI Insights (data transformation) in the Microsoft Learn documentation.

    Here is the comprehensive breakdown of the AI-powered self-service features currently available, categorized by how you apply them.

    1. AI Visuals (No Code Required)

    These are standard visualizations you can drag and drop onto your canvas.

    • Key Influencers: Analyzes your data to understand which factors drive a specific metric (e.g., "What influences Customer Churn to be 'Yes'?").

    • Decomposition Tree: Uses "AI Splits" to automatically find the highest or lowest value in the next dimension of your hierarchy.

    • Q&A (Natural Language): Allows users to ask questions in plain English (e.g., "Total sales by region") and generates a visual automatically.

    • Smart Narrative: Automatically generates text summaries and dynamic insights based on the data in your report page or specific visuals.

      2. Built-in Analytical Features (On Standard Visuals)

      These are AI features embedded into standard charts (like Line or Scatter charts) via the Analytics pane (magnifying glass icon).

      • Anomaly Detection: Automatically detects anomalies in time-series data and provides explanations.

      • Forecasting: Predicts future values based on historical trends (available in Line Charts).

      • Clustering: Automatically groups data points with similar characteristics (available in Scatter Charts).

      • "Analyze" (Quick Insights): Right-click a data point in a visual > Analyze > "Explain the increase/decrease" or "Find where this distribution is different."

        3. AI in Power Query (Data Prep)

        • Column from Examples: Uses AI to detect patterns in your input to generate complex M transformations (e.g., extracting names from email addresses) without coding.

        • Fuzzy Merge: Uses AI algorithms to join tables based on similar (but not identical) text strings.

          4. Advanced AI (Requires Premium/Fabric)

          • Copilot for Power BI: Uses Generative AI to create report pages, write DAX measures, and summarize semantic models.

          • AI Insights (Dataflows): Access to pre-trained models from Azure Cognitive Services (Sentiment Analysis, Key Phrase Extraction, Image Tagging) directly in the Power Query editor.

          • AutoML: Allows business analysts to build, train, and invoke Machine Learning models directly within Power BI dataflows.

            Where to find the official documentation:

            You can find the deep-dive technical details for these features here:

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi powerbiexpert22,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to burakkaragoz  for prompt and helpful responses.

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi @powerbiexpert22,

     

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar