Forum Discussion

pbiforum123's avatar
pbiforum123
Post Patron
6 years ago
Solved

Help required to implement security...

For one of my security requirement. I will have following table as input and thinking of following table as output but dont think that is the optimized way of doing it. For lesser number of records i...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi pbiforum123 

     

    Please see follow the steps in the video.


     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi pbiforum123 

 

The groups step ( list ) that we extracted from the security tables column can be replaced by an independent table with a list of all the groups, you can still refer to other objects outside of the scope of your query.

 

Power BI is designed to handle large volumes of records so expanding the number of rows is not an issue as long as you keep the columns in this table to the minimum.

 

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

pbiforum123's avatar
pbiforum123
Post Patron
6 years ago

Mariusz I need your help in getting the groups from independent table. Rest was understandable! Please help...

 

"The groups step ( list ) that we extracted from the security tables column can be replaced by an independent table with a list of all the groups, you can still refer to other objects outside of the scope of your query."

 

I tried like below, hope this the right approach..

 

groups = List.RemoveNulls( List.Distinct( #"Replaced Value"[group] )),
groups1 = List.RemoveNulls( List.Distinct(group1[group1])),
#"Added Conditional Column" = Table.AddColumn(#"Replaced Value", "new group", each if [group] = null then groups1 else {[group]}),

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi pbiforum123 

     

    You can create extra Table groups, like below

    next, add a step to convert it to list.

    and later you can use it in your code like below

    #"Added Conditional Column" = Table.AddColumn(#"Replaced Value", "new group", each if [group] = null then groups else {[group]}),

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

  • pbiforum123's avatar
    pbiforum123
    Post Patron
    6 years ago

    Mariusz Thanks a lot! I exactly did the same as I mentioned in my previous post I think you missed it out. I got some good understanding on M Script to start with. It is all because your help and assisstance. 

     

    groups = List.RemoveNulls( List.Distinct( #"Replaced Value"[group] )),
groups1 = List.RemoveNulls( List.Distinct(group1[group1])),
#"Added Conditional Column" = Table.AddColumn(#"Replaced Value", "new group", each if [group] = null then groups1 else {[group]}),

     

    Please share some tutorials if you have any about the M Script.