Right Outer join using DAX/M

[MartinDra]

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

[PC2790]

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]

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"