RLS implement in PowerBI or on Azure DB

  • alex.palmer

    SSCrazy

    Points: 2277

    Hi

    we have a requirement to implement RLS for a finance report.

    We're discussing the pros and cons of implementing RLS on the DB or in PowerBi.

    My question is, if I implement RLS on the SQL DB will this be reflected in the PowerBI dataset?

    So that User A only sees User A information and User B only sees User B's information in the PowerBI report

    Or

    Will the PowerBI dataset only contain the data that the RLS security allows the service account to see and the RLS will be lost in the dataset

    Hope that makes sense

    Alex

  • Site Owners

    SSC Guru

    Points: 80376

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply