Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a requirement for dynamic security that I haven't been able to figure out. Not sure if it's a tool limitation or just requires more complicated DAX than I understand.
The requirement is to secure on a combination of Country and Business Unit. These are both attributes/master data fields. So I have a fact table, and then 2 dimension tables. (1 dimension table contains Country, 1 contains BU)
Below is an example from the Security table
User | Country | Business Unit |
Joe_Smith@abc.com | CA | BU025 |
Joe_Smith@abc.com | US | BU026 |
When I try to add the DAX filter logic, I have to pick 1 of the dimension tables to apply the filter, and if I try to reference the column from the 2nd dimension table, I get an error during the syntax check.
"The column 'table2[Country]' either doesn't exist or doesn't have a relationship to any table available in the current context."
I was able to get this to work in a POC I did but both Country and Business Unit were on the same table in that example.
The two fields we are securing on come from 2 different dimension tables that both relate to the fact table. Let me know if the pictures below are not sufficient.
I have the same use case. Have you found any solution or workaround?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |