Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

How can i pass id with email address in Power BI Embedded App owns Data

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 

  1. Users (User Id, Email, Document Id)
  2. Fact Table ( FactId, userId, Document id

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

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , refer if this can help

https://www.youtube.com/watch?v=yNF-_l2f7w0&feature=youtu.be

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors