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

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

Hi Anonymous,

In Power BI service, Azure Analysis Service data source doesn't require any gateway. So you needn't to create a data source in Manage Gateways. 

Best Regards,
Qiuyun Yu

thankyou @v-qiuyu-MSFT for the useful information. i did not find the same in the documentation.

so in this case the reports always runs with the account which we used to connect to azure analysis services from power bi desktop right?

Also if i have multiple reports that are using azure analysis services and if i want to change the account,do i need to open all the respective reports and redeploy to power bi service?

Regards,

CLR

Hi Anonymous,

When you go to dataset settings, as long as you type the valid credential which is able to access Azure Analysis Service, the dataset can get data fine. 

If you have multiple reports get data from Azure Analysis Service, you can go to dataset settings then edit credential for each dataset. You needn't edit in desktop then redeploy, you can just do it in Power BI service. 

Best Regards,
Qiuyun Yu

Hi @v-qiuyu-MSFT ,

i am using the live connection to Azure Analysis Services but i dont see any data sources in my settings.

FYI i am a power bi administrator role and i have deployed this report to power bi service.

Can you please check how can i update my data source credentials to an other one?

Hi Anonymous,

Please open the report in Power BI desktop, go to Data Source Settings check if only this Azure Analysis Service data source exists. 

Best Regards,
Qiuyun Yu

Hi v-qiuyu-msft,

As suggested above i opened the pbix in desktop went to 

File --> Options and Settings --> Datasource Settings and i see the below connections in under Global Permissions

File --> Options and Settings --> Datasource Settings and i see the no connections in under Datasource settings for current file.

However if i go directly to Edit Queries and Datasource Settings i see only the below popup screen which has the azure connection details.

Not sure where you would like me to remove the connections for other sources is it under Global Permissions,please suggest,thanks

Regards,

CLR

Hi Anonymous,

Please publish this report "Sales Actuals_Azure_Test2" to Power BI service, then go to the Dataset Settings, check if any gateway is required. As it's live connection, Data Source Settings should not available as well. Please upload screenshot about dataset settings of this report here. 

Best Regards,
Qiuyun Yu

Hi v-qiuyu-MSFT,

As suggested i have deployed the report and find the screenshot of the dataset settings and i cant find the datasource details over here.

FYI,i had also attached the dataset settings for another report above which even does not show my datasource settings but both the reports are working good.

Please suggest how to change my datasource credentials?

Regards,

CLR

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. 

Best Regards,
Qiuyun Yu