Forum Discussion
creating a row level security based on id and start and end dates to filter out a table
creating a row level security
based on user id and start and end dates to filter out users table
and this access is controlled from another table where managerid ,userid and start and end dates reside
filter managerid using username()
a manager may have access to multiple users
but im not able to filter the subsequent user table based on manager and each users start and end dates.
If anyone is able to help me out to acomplish this , thanks.
4 Replies
_AAndradeResident Rockstar
Without any sample pbix file to try understand what is happening, the best advice I could give you is read the Reza blog and watch his videos about this content.
Like this: https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bii need help designing the dax for manage roles.
i have a
user table (userId,jobId,Date)
and a access table (managerId,userId,Date)
the manager may have access to multiple users
and i need to employ an access control based on the dates and user from access table and restrict the data from the user table .. any help will be appreciated, thanks- _AAndrade
Sorry, I can't help you with only the explanation that you provide. Dinamic RLS it's complex to implement because we need to see the relationship between tables and apply dax measures.
any help will do .. i am not able to share the files as they contain sensitive data ..
if u can guide me to some way i can fullfil my use case would be much appreciated.
.. a simple dax query to help me out would be nice too
