Forum Discussion

msofficesolutio's avatar
msofficesolutio
Helper II
8 years ago
Solved

AI driven Data Analysis functionality in power bi dashboard

Hi Everyone,

 

I was going through few power bi related videos and found one interesteting video

 

https://www.youtube.com/watch?v=uo_gaeN9zP0(New AI-driven analytics and data storytelling in Power BI)

 

 

In this video one functionality is displayed "Analyze" which explain reason of variation in data points, can any one explain how to impliment this functionaliy, I tried to search but not found any learning video on that.

 

Interesting Links
Need Help
Tutorial Requests

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    HI msofficesolutio

     

    This functionality is still at is very early stages although it's been release an few month ago.

     

    There are several limitaitons as you can check on this link.

     

    Here's a list of the type of queries it does not yet handle:

     

    • TopN filters
    • Include/exclude filters
    • Measure filters
    • Non-additive measures and aggregates
    • Show value as
    • Categorical columns on X-axis unless it defines a sort by column that is scalar. If using a hierarchy, then every column in the active hierarchy has to match this condition
    • Non-numeric measures: model measure support is limited to sum and count only right now.
    • Limitation in data conectivity
      • Direct query
      • Live connect
      • On-prem RS
      • Embedding

     

    Regards,

    MFelix

    • msofficesolutio's avatar
      msofficesolutio
      Helper II
      8 years ago

      Hi MFelix,

       

      Thanks for your suggestion, I tried creating few dashboards with limitations mentioned by you but this specific option could not be found in any dashboard.

       

      Will you be able to share any link which showcase how to develop dashboard with this functionality.

  • querixa's avatar
    querixa
    Helper IV
    5 months ago

    I understand you're looking for that ""Analyze"" feature for variation explanation. That specific functionality is part of Power BI's AI visuals, like the ""Key Influencers"" visual, which helps explain metric variations. However, it requires a Copilot license for full natural language interaction.

    If you're looking for an alternative that provides similar instant insights without additional licensing, you might find this approach interesting: I've been using PowerMind, an AI assistant embedded directly in Power BI dashboards. It answers natural language questions about your data and works with any data model. It's particularly useful when you need quick explanations for data point variations without switching contexts.

    You can see how it handles similar analysis in this LinkedIn demo: https://www.linkedin.com/feed/update/urn:li:activity:7438407183161065472