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?
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 firstname.lastname@example.org --> MyComputerName\Localuser
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, 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, 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:
He says that at 4:20 approx...