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
GilbertQ's avatar
GilbertQ
Super User
8 years ago

Hi Anonymous

 

What I think you possibly need to do, is to map your Power BI Login name to the Local name on your SSAS Instance.

 

In the Power BI Service, click on Manage Gateways

Then click on the Data Source.

Then click on Users

Then click on Map Users

Then map your Power BI login [email protected] --> MyComputerName\Localuser

 

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