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.
Hi,
I've created manage aggregation model it's working fine and I tested on Dax studio, all quries are navigating to aggregated tables.
Bur after creating role for RLS on one table, all visuals are failing and giving below error.
And When I see aggregated in data view tab, it's showing below error.
Solved! Go to Solution.
Hi @Anonymous ,
Does your RLS meet the following condition?
"To work correctly for aggregations, RLS expressions should filter both the aggregation table and the detail table."
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Found the problem.
By misktake I've added report level filter from aggregated report after removing that filter RLS worrking fine.
All filter should come from dimesion tables or DQ fact(only if required).
"To work correctly for aggregations, RLS expressions should filter both the aggregation table and the detail table."
Thank you Both for the support .
Hi @Anonymous ,
Which method do you use to configure RLS?
Does your account have access permission?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Basically it's Manage aggregation model, you can refer below doc. also.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
I've created a composite model:
1. Fact on Direct Query
2. Aggregated table on Import
3. Dimensions are on Dual mode.
I've one customer dimension where I've added role cust. name = " abvcfd", then I'm testing on desktop only.
Hi @Anonymous ,
can provide a sample file or more information?
Hi,
It's in DQ, how can provide data?
I can provide 2-3 excel, will that works.
Basically it's Manage aggregation model, you can refer below doc. also.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-aggregations
I've created a composite model:
1. Fact on Direct Query
2. Aggregated table on Import
3. Dimensions are on Dual mode.
I've one customer dimension where I've added role cust. name = " abvcfd", then I'm testing on desktop only
Hi @Anonymous ,
does the user "DESKTOP-1234/ABC" have access rights to the database / tables?
I don't think so i've define any roles in DW.
So, I need to defines roles in DW on fact tables or all tables or what level I have defines roles.
Even if I select "Customer name" roles only then also it's failing.
But even
Hi @Anonymous ,
Does your RLS meet the following condition?
"To work correctly for aggregations, RLS expressions should filter both the aggregation table and the detail table."
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Found the problem.
By misktake I've added report level filter from aggregated report after removing that filter RLS worrking fine.
All filter should come from dimesion tables or DQ fact(only if required).
"To work correctly for aggregations, RLS expressions should filter both the aggregation table and the detail table."
Thank you Both for the support .
Hi @Anonymous ,
can you post a screenshot of the role definition?
Hi @Anonymous ,
I think if you access the table with Direct Query and run this query as another user, the data will be queried with the appropriate user rights.
The user therefore needs corresponding access rights (role) in the SQL database (DW).
Unfortunately, I am not very familiar with this topic.
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 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |