Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Experts,
I'm working on a Power BI Embedded App owns data. I have a multi-tenant web application.
I've implemented the RLS logic to show logged in user's respective data on the web by using USERPRINCIPALNAME( ) DAX.
Now my new requirement is to implement Document Id logic. Let me explain.
I've tables
A user has many document Ids.
Now if user 1 clicks on document 1 then only respective user 1 and respective document 1 data should be shown.
To handle user-related data I'm applying for Roles on Users table like Email = USERPRINCIPALNAME(). But it's showing me all document data which is wrong, it should only show document 1 data.
Here my question and requirement are how can I pass document id to apply a filter on the dataset to load only User1 and document1 data.
Here is JSON that I'm passing through.
{
"accessLevel": "View",
"allowSaveAs": "false",
"identities": [
{
"username": "test@gmail.com",
"roles": [
"UserRole"
],
"datasets": [
"xxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx"
]
}
]
}
Thanks
@Anonymous , refer if this can help
https://www.youtube.com/watch?v=yNF-_l2f7w0&feature=youtu.be
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.