Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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. )
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.
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"
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
95 | |
88 | |
70 |
User | Count |
---|---|
165 | |
130 | |
129 | |
102 | |
98 |