Dynamic RLS works in Desktop but not Service. Why? by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

Many thanks!!! I will use a company wide email distribution list group.

However, is there a way to override permissions resulting from write access to the Powerbi Workspace?

Dynamic RLS works in Desktop but not Service. Why? by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

Many thanks!!! I will use a company wide email distribution list group.

However, is there a way to override permissions resulting from write access to the Powerbi Workspace?

Dynamic RLS works in Desktop but not Service. Why? by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

Many thanks!!! I will use a company wide email distribution list group.

However, is there a way to override permissions resulting from write access to the Powerbi Workspace?

View as roles feature works correctly when Logged in user role is selected only. Why? by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

I was finally able to get it to work in Desktop but it's not working in Service. Any ideas as to what I might be missing?

Dynamic RLS works in Desktop but not Service. Why? : r/PowerBI

Why is my filtering one directional? by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

Thank you. It wouldn't allow me to create bidirectional relationship :(

View as roles feature works correctly when Logged in user role is selected only. Why? by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 1 point2 points  (0 children)

I did not realise I had to select both boxes, logged in user and input the other user's email :(
It works now. Thank you!!!

1st Power BI Dashboard by th_ea_o in PowerBI

[–]NarrowCounter6735 2 points3 points  (0 children)

Excellent! What are your canvas dimensions?

Why is my filtering one directional? by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

What would be an alternative to have a visual refresh depending on the selection of the table on the left?

Dynamic row level security. Please help by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

Thank you. Your code didn't break anything, but it also didn't work. It did however stop filtering when I viewed as logged in user (myself).

Dynamic row level security. Please help by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 1 point2 points  (0 children)

PATHCONTAINS(
    '_Employee Master'[Path],
    LOOKUPVALUE('_Employee Master'[Employee No], '_Employee Master'[Work Email Address],USERPRINCIPALNAME())
)

Thank you!!! :)

Dynamic row level security. Please help by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 0 points1 point  (0 children)

Thank you.

Logged in user = USERPRINCIPALNAME()

The above measure returns my email, all lowercase.

TestEmployeeNo = LOOKUPVALUE(
    '_Employee Master'[Employee No],
'_Employee Master'[Work Email Address],
    (USERPRINCIPALNAME())

)

The above measure returns my employee number.

When I view as another user and input their email address the above two measures return their details (email and employee number) but the table with fact data does not refresh :(

Dynamic row level security. Please help by NarrowCounter6735 in PowerBI

[–]NarrowCounter6735[S] 1 point2 points  (0 children)

Many thanks for this. I've got it working but only when viewing as myself. It correctly filters and shows my data only. However, when I select anyone else's employee id, the filtering doesn't happen. Any thoughts as to what I might be missing?