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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mittalpatel130
Helper III
Helper III

New Workspace > Privacy Settings missing

Hello - 

 

I've implemented Power BI Embedded solution (Apps own data) with Row level security. Embedded it successfully, however the Row Level Security is not working. I found below details, where we need to change the Privacy Setting on Workspace to get it working. It says that RLS works with Read-only members in Workspace. 

 

Where can I find this settings on New Workspaces? 

 

Thank you. 

 

Capture1.JPG

2 REPLIES 2
blopez11
Resident Rockstar
Resident Rockstar

That screenshot is from the old v1 workspaces

 

Have you seen this article?

 

https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-row-level-security

 

@blopez11  - Thank you for the response. 

 

Yes I checked this one. I'm bit confused as I read the link you provided. 

 

My scenario - 

1. Data Source - SQL Server On-premise

2. Dynamic RLS is configued in Power BI Desktop

3. Published Reports to Premium Capacity, upgraded Workspace

4. Embedded Solution - Apps Own Data using JavaScript (used GenerateToken method)

5. Added EffectiveIdentity as below in the JavaScript GenerateToken Call. 

 

{
    "accessLevel": "View",
    "identities": [
        {
            "username": "EffectiveIdentity",
            "roles": [ "Role1", "Role2" ],
            "customData": "MyCustomData",
            "datasets": [ "fe0a1aeb-f6a4-4b27-a2d3-b5df3bb28bdc" ]
        }
    ]
}

 

 

As per the link, these are the limitations of Token based embed. Does that mean RLS won't work with my scenario?

 

Token-based Identity limitations

  • You can use RLS only if you have a dedicated capacity.
  • RLS doesn't work with SQL Server on-premises.

Thank you.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors