Forum Discussion
Row Level Security - MdxScript(Model) (45,60) Calculation error in measure
I understand that the easier approach is to create separate reports and publish them, but we are trying to reduce the maintenance of multiple reports.
I was able to bypass the error by changing the connection mode from direct query to mixed for ACCESS_CONTROL_VIEW.
And I was able to achieve the required functionality i.e. Certain users can access certain pages based on which page they have access to. This is not a straight forward and secure way but it works for now.
Youtube Link -
https://www.youtube.com/watch?v=eHzkn3pSJ4g&t=300s&pp=ygUWcGFnZSBzZWN1cml0eSBwb3dlciBiaQ%3D%3D
It's a great pleasure to know that you've found a solution. To help other members of the community, can you mark your response as a solution? This way others who are experiencing similar problems can find the answer faster.
If you need any help with this, please feel free to let us know.
Thank you for your cooperation and support!
Best wishes