Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How can i modify my dataflow ?

Hi, 

 

I 'm using Microsoft 365 usage analytics report. It works very well but in the section Adoption, i can see 11 424 Enable user. 

 

 
 

After a quick search, i found it's a sum of my enable user on my A1, A3 and A5 subscription and other subscription

 

 

I only want to see the data from A3 subscription...how can I do that ?

 

Thank you

 
Dataflow
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You can customize and build additional reports using Power BI Desktop, start by connecting directly to the ODATA reporting APIs from Microsoft 365 that power these reports, add a slicer visual to filter these A1, A3, A3 or other selections, see more details: Customize the reports in Microsoft 365 usage analytics . Then you may consume the new customized .pbix file in dataflow.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You can customize and build additional reports using Power BI Desktop, start by connecting directly to the ODATA reporting APIs from Microsoft 365 that power these reports, add a slicer visual to filter these A1, A3, A3 or other selections, see more details: Customize the reports in Microsoft 365 usage analytics . Then you may consume the new customized .pbix file in dataflow.

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      sorry for the late reply.
      As a beginner on PowerBI, I preferred to take a training course on LinkedIn learning before answering.

      I still have a lot to learn, but I now understand your answer.

       

      To be more precise about my initial application, it is only this indicator that I wish to change

       

       

      I've added a filter that allows me to select the licenses I want to see, but that doesn't change the values

       

       

      11,087 is the sum of my A3+A1+A5 licenses.
      I'd like to see that the sum of the A3 and A5 licenses only

       

      The data field for this visual corresponds to

       

      Wouldn't the easier way to change the syntax?

       

      What do you think ?