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

Question

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, and I connect using a LOCAL USER account. I don't have the possibility of connecting with a domain user.

I can configure the Gateway and the data source on the service, and I can also refresh the datasource, but when I try to refresh from the report, I get an error.

Is it possible to do this using a local user account, or the only way is with a domain user??

If I need the domain user, I would need to configure an Active Directory server and domain just for solving this problem?

Thanks!

gilbertq · Answer

Hi&nbsp;Anonymous&nbsp;What I think you possibly need to do, is to map your Power BI Login name to the Local name on your SSAS Instance.&nbsp;In the Power BI Service, click on Manage GatewaysThen click on the Data Source.Then click on UsersThen click on Map UsersThen map your Power BI login bob@domain.com --&gt; MyComputerName\Localuser&nbsp;

gilbertq · Answer

Hi there, have you changed it from Effective User Names to Custom Data?

anonymous · Answer

Thanks&nbsp;GilbertQ&nbsp;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.&nbsp;