Forum Discussion

Helper I

9 years ago

Solved

Does row level security work with embedded non-directquery mode?

I cannot seem to get row level security to work with my model.

I have data loaded to a .pbix file and the pbix file has been loaded to a workspace collection.

This is not directquery. The data is in the model.

Should I expect Row Level Security to work for this scenario?

Eric_Zhang
9 years ago
rnoone wrote:

Ah, thanks. I think I forgot the role name.

rnoone

RLS works regardless import or direct query mode. Check Row level security with Power BI Embedded.

var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id, "User Name", roleList);'

So have you figured out the problem now?

4 Replies

MWilson929
Frequent Visitor
9 years ago
I've not tried it myself, but have you defined the security roles in the model and passed the role through the API call? Is it working for you with direct query or is this the only way you've tried?

Best,
- rnoone
  Helper I
  9 years ago
  Ah, thanks. I think I forgot the role name.
  - Eric_Zhang
    Microsoft Employee
    9 years ago
    rnoone wrote:
    
    Ah, thanks. I think I forgot the role name.
    
    rnoone
    
    RLS works regardless import or direct query mode. Check Row level security with Power BI Embedded.
    
    var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id, "User Name", roleList);'
    
    So have you figured out the problem now?