Forum Discussion

rnoone's avatar
rnoone
Icon for Helper I rankHelper 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 i...
Need Help
  • Eric_Zhang's avatar
    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?

     

     

MWilson929's avatar
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's avatar
    rnoone
    Icon for Helper I rankHelper I
    9 years ago

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

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft 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?

       

       

      • rnoone's avatar
        rnoone
        Icon for Helper I rankHelper I
        9 years ago

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