Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

How to send USERPRINCIPALNAME to dynamic query to return results based on logged in user

Hi, I have a requriement to show data based logged in user. The logged in user (USERPRINCIPALNAME) need to be passed to query as  a parameter user_id to the backend direct query. Data is huge cannot...
Need Help
muhssamy's avatar
muhssamy
Icon for Resolver I rankResolver I
2 years ago

1- create a table contains the user emails in your database

2- make a relationship in power bi datamodel between this table and your fact

3- filter the new table using Row level security.

 

this will achive your Goal