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

Thanks GilbertQ for your answer, but I already tried that and I have the same problem.

I also read a lot of posts about this, but all the answers refer to a DOMAIN user, so I start to think that the only way of solving this is using a domain user, but I want to confirm that, becouse it would be really inconvenient for me to do that.

 

GilbertQ's avatar
GilbertQ
Super User
8 years ago
Hi there, have you changed it from Effective User Names to Custom Data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

    • GilbertQ's avatar
      GilbertQ
      Super User
      8 years ago
      I think if you could add in the RLS the Power BI address to get it working
      • 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!!