Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

0

On-Premise Data Gateway to Azure Analysis Services Connection Error

Unable to connect: We encountered an error while trying to connect to asazure://northcentralus.asazure.windows.net/pxax1. Details: "An invalid connection string has at least one of the passed arguments which does not meet the parameter specification. Please check the data source connection string."Hide details Activity ID: 2baf381a-e1cf-4d28-94e7-592cc100d5bf Request ID: 5f01f8f5-2af3-8209-51ce-aeb87383ef0a Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net Status code: 400 Error Code: DM_GWPipeline_Gateway_ProviderDataAccessArgumentError Time: Mon Oct 30 2017 10:42:17 GMT-0400 (Eastern Daylight Time) Version: 13.0.2912.189 Underlying error message: Authentication failed: User ID and Password are required when user interface is not available. DM_ErrorDetailNameCode_UnderlyingHResult: -2147024809 Hi All, i am trying to add the data source under my gateway to Azure Analysis Services but it is showing me the above error,but i am able to connect to the server using management studio and also using power bi desktop without any issues

Status: Delivered
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous,

 

As it's live connection, Data source Settings will not be available. So you need to modify credential in Power BI desktop then republish. 

 

But one thing is strange, I really remember I test before Azure Analysis Service doesn't require any gateway. As current my azure subscription is disabled and can't test again, if you have any other question, I would suggest you create a support ticket to get dedicated support. 

 

Support Ticket.gif

 

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Status changed to: Delivered