Row-level security and Page-level access

[SanKing]

Dear Experts,

I would like to ask you for your help with combining row-level security and Ppage-level access in one report.

I believe that for both I should use tables, but how can I combine both tables in one function in Manage roles with User = USERPRINCIPALNAME()?

Thank you in advance for your help!

Best regards

[RockPowerBI]

if user have url of other page. they access through this solution right?

[v-binbinyu-msft · Accepted solution]

Hi @SanKing ,

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SanKing]

Thank you @v-binbinyu-msft ,

I would like to ask one more question related to this topic: I have a database with orders, where I have DataAccess defined in few separate columnd and I don't have all users that should have access with limited or not data (example below) 

In Manage roles I could set separate filters for each user, ,how can I do this in case of managing this Access through table without filters for Dataset?

Thanks in advance for your help!

[v-binbinyu-msft]

Hi @SanKing ,

Please try to create a measure and add it to the visual's filter pane to restrict access data.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SanKing]

Thank you @v-binbinyu-msft ,

Could you please guide me with this measure?

And does it mean that I need to add filter to every visual in the report?

Thanks in advance for your help,

Best regards

[v-binbinyu-msft]

Hi @SanKing ,

Sorry, this question is off-topic from the previous topic. To make the post more relevant, please consider marking the replies that help you, and creating a new case for the new question, as this will better help other users with similar questions and allow more people to participate.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.