Forum Discussion

pushkarajb's avatar
pushkarajb
Frequent Visitor
5 years ago

Azure Analysis Services authentication

Hi,   We are trying to set up a new Azure Analysis Services(AAS) model which will be locked down only to a small set of report developers as it will contain sensitive data. These report developers...
Need Help
pushkarajb's avatar
pushkarajb
Frequent Visitor
5 years ago

Hi Stephen,

 

Many thanks for your response! I agree that security can be managed at the Power BI Service level.

However, if all users are provided READ access to the Tabular model in AAS, they will be able to see and query the model via Power BI Desktop.

As the data is very sensitive, we want to restrict access to the model to only specific report developers and not report viewers.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi pushkarajb ,

     

    I think you may need Row-level security (RLS) to restrict data access.

     

    However, for Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop. 

     

    Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.