Forum Discussion

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,...

Anonymous

Not applicable

8 years ago

I tried both options, same result... :smileyfrustrated:

Icon for Super User rank

Super User

8 years ago

I think if you could add in the RLS the Power BI address to get it working

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
  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
    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

Related content