Help required to implement security...

Hi pbiforum123 

No idea why you can not open the file as just checked and its working fine on my end.

Instead, please see the below M script, you can paste it into the advance editor of a blank query and investigate the steps.

Let me know if you need any assistance.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WSkxKdkjPTczM0UvOz1XSUUpUitWJVkpJTUMRTQKLVlRWoYgqxcYCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [user = _t, group = _t]),
    #"Renamed Columns" = Table.RenameColumns(Source,{{"group", "_group"}}),
    #"Replaced Value" = Table.ReplaceValue(#"Renamed Columns","",null,Replacer.ReplaceValue,{"_group"}),
    groups =  List.RemoveNulls( #"Replaced Value"[_group] ),   
    #"Added Custom" = Table.AddColumn(#"Replaced Value", "group", each if [_group] = null then groups else { [_group] }),
    #"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"user", "group"}),
    #"Expanded group" = Table.ExpandListColumn(#"Removed Other Columns", "group"),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded group",{{"group", type text}})
in
    #"Changed Type"