Reply
Highlighted
Regular Visitor
Posts: 18
Registered: ‎02-24-2018
Accepted Solution

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.

 


Accepted Solutions
Moderator
Posts: 7,838
Registered: ‎03-10-2016

Re: AI driven Data Analysis functionality in power bi dashboard

@msofficesolutio,

Please check the example in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1NogW7rJtVIRlbhJdR0

Regards,
Lydia

View solution in original post


All Replies
Super User
Posts: 1,672
Registered: ‎09-19-2016

Re: AI driven Data Analysis functionality in power bi dashboard

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Regular Visitor
Posts: 18
Registered: ‎02-24-2018

Re: AI driven Data Analysis functionality in power bi dashboard

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.

Moderator
Posts: 7,838
Registered: ‎03-10-2016

Re: AI driven Data Analysis functionality in power bi dashboard

@msofficesolutio,

Please check the example in the PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1NogW7rJtVIRlbhJdR0

Regards,
Lydia