Complicated roles

I’m having trouble getting my credentials in the report.

I want the shop to be unable to choose another RKS or another country in the filter when entering a report made available to it. A store should only see its country and its RKS and the ranking of stores throughout the country, and compare its revenue with that of other stores (lowest table).

Is this even possible to do? The cube is thrown on Azure, but I tried to reflect the model in Power BI.

Sample_pbx

Hi @Harris,

Have you examined Row Level Security?

https://forum.enterprisedna.co/t/scale-your-power-bi-reporting-with-row-level-security/469

https://forum.enterprisedna.co/t/row-level-security/4415

Also check the search option for more related content, like:

Hi @Harris, we’ve noticed that no response has been received from you since the 25th of March. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

A response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box. Thanks!"

Hi @Harris, a similar topic was covered in this forum thread link. You might get additional tips here.

1 Like