PowerBI Gateway cannot use data source from Analysis Service. Invalid connection credentials.

[dhacf]

Hi,

The error message looks like this.

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	da94f4f1-5bd6-42b5-4d83-700c17f10bc9
Request ID:	f854c442-1af7-1cd0-7c70-c115e0a2f703
Cluster URI:	https://wabi-west-europe-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Mon Sep 03 2018 15:35:39 GMT+0200 (Central European Summer Time)
Version:	13.0.6517.123

casemate-aws-gateway1:

Invalid connection credentials.

a

Troubleshoot connection problems

I have a machine with two SQL instances. One regular SQL server which the Gateway connects to without problem.

There is also a Analysis Service instance. This error message appears when i try to connect to it. Googling that Error Code doesn´t give any help at all. And i also don´t know what that Cluster URI is.

The Gateway itself has no connection issues. There is also a AD user added to manage the Analysis service databases.

Thank you for any help

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".