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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

0

Powerbi embedded row level security

I have setup roles in powerbi desktop. Can view as roles in desktop. But while embedding i'm getting this error

 

 

{ code: 'InvalidRequest', message: 'Creating embed token with effective identity requires dataset to be provided' }

 

 

My payload to token fetch API is

 

 

{ 
"accessLevel": 'View',
"identities": [ { "username": "username", "roles": [ "role" ], "datasets": ["datasetid"] }]
}

 

 

 

Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @powerbii

 

Are you embedding to Power BI users via user owns data?

 

If it is, RLS works the same as it does within the Power BI service directly. There's nothing more you need to do in your application. Please check if you have added users as member to the dataset RLS role correctly follow this document: https://docs.microsoft.com/en-us/power-bi/service-admin-rls#manage-security-on-your-model

 

If you are using app owns data, please follow this document to check if all steps are taken: https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security

 

Best Regards,
Qiuyun Yu 

powerbii
Regular Visitor

@v-qiuyu-msft I'm using app owns data. I have taken all the steps in still it's happenning.

 

- i have created the role in powerbi desktop.

- i can see the role in "view as roles" in powerbi desktop

- published the report

- copied the dataset id from powerbi web

- updated the token fetch JSON with username, roles and datasets

{ 
"accessLevel": 'View',
"identities": [ { "username": "username", "roles": [ "role" ], "datasets": ["datasetid"] }]

 - now i'm getting this error.

v-qiuyu-msft
Community Support

Hi @powerbii

 

Till now, it's hard to provide further help on side. I would suggest you create a support ticket to let engineers look into the issue on your side. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Delivered
 
researcher3000
New Member

Hello,

Can you guys share the solution. I met the same situation.