Forum Discussion
SSAS Datasource creation at Gateway Failed
Dear experts, I have connected SSAS cube live in Power BI Desktop using system account credentials and created report and published to Power BI service, when i try to create Datasource at Gateway wi...
Was it the SSAS admin account - as the admin account will have access to all cubes and roles. This looks like the permission was assigned but not to the roles of the cube. If it's the admin, it should not need to be in the roles as it's "Admin god all rights".
Hello,
It is not SSAS Admin account, but service account with access to 2 databases to connect to Power BI and this service account is having admin permissions added.
Best
Venu
The service account should be added to a "read" role that you create on the cube itself in SSMS. It doesn't need full permissions to the cubes, just a read permission is fine. It just needs admin on the gateway is all.
- Hi there
If the data source is an SSAS On Premise database you will have to map the UPN (UserPrincipalName) to the Domain\UserName in order for this to work.
If it is AAS then you should be fine by adding the users to a specific role.
