SSAS Credentials Work in PowerBI Desktop but Not in PowerBI Service

[cpun]

One of the data sources in my report is an SSAS OLAP cube and below are the permission settings that I am currently using. My credentials allow me to refresh the data in PowerBI desktop. However, when I try to refresh the data in PowerBI service using these same credentials, an error appears saying my credentials are invalid.  Only one option is given for Authentication method, which is the one in the screenshot. 

Has anyone experienced this issue before? Any help would be appreciated. 

[Anonymous · Accepted solution]

@cpun 

It looks like you need to map your Power bi login username to the one that accessed to AS server. Please follow this section of the official doc: 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas#map-us...

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi there

When setting up the Gateway you need to use a user account which has got Admin rights to the SSAS Server.

Here are more details: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas