Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Honour Row-Level Security with XMLA Endpoints

  Is it currently possible to honour row-level security with the XMLA endpoint, we're pulling data to present to end users but the cubes require the effective username to be supplied, trying the Cha...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

 

What are you trying to do with the XMLA end point?

 

You would need to log into the XMLA end point, and as long as you are in a defined role with the correct permissions you should be able to query the cube.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi GilbertQ 

    Cheers for your response.

     

    We're calling the XMLA Endpoint in Power Bi Premium with a service principal from an AppService in Azure - It's a intranet application we have the users UPN in context of each call we just return data to the front-end web application.  (that's all working correctly)

     

    We have a seperate system that manages the RLS , but for it to function we need to include the UPN in the request , when we try including the user UPN  we got the, perviously mentioned, error! 

    Looking at the documentation it seems that we should be able to use the EffectiveUserName element.

     

    I'm reading conflicting information; it should work if we grant the principal server rights, or; it's not supported in PBI Premium - 

    Any ideas?

     

    Cheers,Ears.