Forum Discussion
SSAS Datasource creation at Gateway Failed
Hi All,
thanks for the support, after adding the service account to the admin group i am able to create Gateway connection.
when i publish the dataset to Power BI Service and try to access the Dataset and Report in power bi service i am getting below error message, though i am using the same accounts for both PBI Desktop and PBI server.
Best
Venu
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.
