Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Connection to SSAS through Gateway using local user account. Is it possible?

I need a sandbox environment for testing some features of Power BI using an SSAS database, and connecting to it from PBI Service through On Premises Gateway. I have the SSAS database on my notebook,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

GilbertQ, I'm not sure if I understand what you mean.

By RLS you mean row level security, right?

Since I'm using SSAS, I understand that RLS can be managed by roles in the SSAS database, and not in Power BI. But in SSAS role membership configuration I can't use Power BI addresses. Just local or domain users.

 

Again, I'm not sure if I got what you mean, sorry if I got it wrong and thanks for your help!!

GilbertQ's avatar
GilbertQ
Super User
8 years ago
What I meant was is that you can pass the Power BI email address through to your SSAS cube
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    GilbertQ, I think that if I don't configure user mapping, I'm actually passing the Power BI email address to my SSAS cube, but the problem is that there is no way I can enable that address to have access to the cube as a regular user. SSAS role membership configuration won't accept that.

    I have just seen a video from "Guy in a cube" on youtube that says that you need a domain... so, sadly, I think that the answer to my question is "it is impossible to do this", which is a real inconvenience for me...

     

    The video is this: 

    https://www.youtube.com/watch?v=ownIGbcRAAU

     

    He says that at 4:20 approx...

     

    Thanks

  • GilbertQ's avatar
    GilbertQ
    Super User
    8 years ago
    Ok that makes sense.

    If you can upgrade to SSAS 2017 there is an option to add an external user