Forum Discussion

djram82000's avatar
djram82000
Regular Visitor
4 years ago
Solved

Update only certain security groups

Hello,

 

I'm new in PowerBI World 😉

 

I have created a report in connection with our active directory.

 

We have quite a few security groups, but I would like to update just a few, not all.
This will allow for faster updates, and I don't need to have all the groups for the reports I'm asked to do.

Is it possible to do this restricted update?

 

Thank you very much !

Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    4 years ago
    I seleted all "groups", 

     Uncheck groups that you do not want. Filter by text will only work if the match 100%, case sensitive and there is not white space in your column.

    If you have filtered, but still getting all the data for all groups, it means that you may have filtered the wrong column. Make sure what you see in power bi desktop is from the same column you are filtering. 

    OR filter the groups after you have expanded the information.

    Let me know how it goes, and take a snapshot of what you see in power bi desktop, if you have futher questions.





6 Replies

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Super User
    4 years ago

    Updating security groups is done in the Azure Portal Active Directory, not in Power BI. 

    Or are you referring to something different?


  • djram82000's avatar
    djram82000
    Regular Visitor
    4 years ago

    Hi,

     

    Thanks for your reply.

    Sorry if I misspoke, my English is not the best.

     

    I created some dashbord in PowerBI with informations from our Active Directory (on premise, not Azure).

    And I would like to limit the update of "groups" (security groups in my case) when I do "update" in the tools.

    Not adding users in groups, only have informations about groups.

     

    Because we have so many groups, I have to wait a long time for my reports to be up to date, especially when I work from outside.

     

    If I could only update the information for the few groups I need, I could save time and be much more efficient.

     

    Thank you

    • Tutu_in_YYC's avatar
      Tutu_in_YYC
      Super User
      4 years ago

      I see! You are visualizing the security groups information in the report.

      You can go to Power Query editor

       

      and at your query, filter only to the security groups that you want:
      1- go to the column that has the groups

      2- click the dropdiwn arrow

      3- Uncheck what you dont want / Check only what you want

       

      • djram82000's avatar
        djram82000
        Regular Visitor
        4 years ago

        Hi,

         

        Thank you.

        Unfortunatly, it doesn't work.

        I create a filter with text and I only select 6 groups.

         

        When I update my repport PBi read all groups not only my 6 groups.

         

        Do you think I have some action to do when I select datas in the Power Query ?

        I seleted all "groups", then in Power Query I expanded some informations like group member samaccountname, top cn and other.

         

        Thanks 🙂

         

         

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, djram82000 

    If your problem has been solved, please accept the helpful reply as solution to close this thread.

    If you still need help, please explain bit more.

     

    Best Regards,
    Community Support Team _ Eason