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 ...
Need Help
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"