Forum Discussion

MartinDra's avatar
MartinDra
Frequent Visitor
4 years ago

Right Outer join using DAX/M

I am looking to build report that shows access level to table and columns from SSAS. 

Issue is that Column Permissions are using a different relationship than Table Permissions

 

the Column Permissions Table only holds information about columns users dont have access to

 

and Tables hold information about the Tables the user has access to.

 

Columns has all columns per tableID.

 

What I am trying to achieve is to show all columns, the ones that they dont have access to as well as the ones that they do (these are blank/dont exist in column permissions. )

 

 

Need Help

2 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    Hey MartinDra ,

     

    As per my understanding of your requirement,you can try using Merge in Power Query.

    Microsoft document here to help you with it.

    • MartinDra's avatar
      MartinDra
      Frequent Visitor
      4 years ago

      Hi, Merge wont work as there are many different roles that have access different tables and columns. 

      if I merge columns permissions and columns I get tableIDs to come through as "null"