How to apply dynamic Row level Security based on Username and location?

Question

asked Dec 1, 2020 in BI by Chris (11.1k points)

Please check this table link

This the table in which I want to implement Row-level security

and I am using this formula

[location] = LOOKUPVALUE([location],[login],USERPRINCIPALNAME())

But it was throwing an error

A table of multiple values was supplied where a single value was expected

How can I resolve

1 Answer

0 votes

1 answer

asked Jan 5, 2021 in BI by Chris (11.1k points)

0 votes

1 answer

asked Dec 31, 2020 in BI by Chris (11.1k points)

0 votes

1 answer

asked Jan 24, 2021 in BI by Chris (11.1k points)

0 votes

1 answer

asked Mar 28, 2021 in BI by Chris (11.1k points)

0 votes

1 answer

asked Jan 3, 2021 in BI by Chris (11.1k points)

Vamsee Krishna · Answer 1 · 2020-12-01T11:42:16+0000

You change the data model by the following steps:

Actual_Table

Access_Table

Final_Table

If you want to learn more about Power BI, then read the Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.