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. T...
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.





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 🙂