Forum Discussion

Nishantjain's avatar
Nishantjain
Continued Contributor
7 years ago

XMLA end point and row level security (RLS)

Hi, Is it possible to manage row level security in power BI service using XMLA end point with SSMS or something similar? I would like to create our amend roles, add or remove users etc Thanks
Need Help
Nishantjain's avatar
Nishantjain
Continued Contributor
7 years ago
Great. Can you point me to any boog/documentation how to do that?
  • Nishantjain's avatar
    Nishantjain
    Continued Contributor
    7 years ago

    GilbertQ 

     

    Thanks for the link. I have gone through the blog and it explain how to connect using XMLA endpoints. Do you know how to extract the information once I have connected using SSMS?

     

    Thanks

    • GilbertQ's avatar
      GilbertQ
      Super User
      7 years ago
      Hi there

      You can connect with Excel, I have not created a blog post on how to do it yet, but it is in my plans
      • Nishantjain's avatar
        Nishantjain
        Continued Contributor
        7 years ago
        Thanks.

        Managing RLS is very manual in the PBI service and is not helpful in our organisation which has over 30000 employees. If you can recommend anything that would be great.

        Thanks