topic Re: Does row level security work with embedded non-directquery mode? in Developer

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

rnoone — Sat, 06 May 2017 10:12:03 GMT

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?

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

MWilson929 — Sat, 06 May 2017 10:14:32 GMT

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,

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

rnoone — Sat, 06 May 2017 15:11:43 GMT

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

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

Eric_Zhang — Mon, 08 May 2017 07:33:35 GMT

@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?

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

rnoone — Mon, 08 May 2017 11:12:28 GMT

Yes, thank you. I should have just read the manual.