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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Param for DB not working when connecting to Azure SQL DB

Using Version: 2.54.4970.961 64-bit (januari 2018)

 

When I create two parameters: AzureServerName and DBName and use them in my settings for the db, he incorrectly uses the name of the second parameter instead of the value.

 

When reloading he is effectively searching for a db called 'dbname' instead of 'customerdb'.

 

It looks like a bug to me, I can't find any way of working around this.

 

 

Creating two params called dbname and azureservername:

CreateParam.JPG

 

Selecting these params in the data source settings screen;

 

SelectParameter.JPG

 

When connecting to the db he takes 'dbname' as a value instead of the actual value of the param.

He effectively tries to connect to the 'dbname' db instead of the customerdb.
You see he computes the value myserver.azure.com;DBName which should be myserver.azure.com;customerdb

 

ParamResult.JPG

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @dirko,

 

I followed your steps but not able to reproduce the issue in the same desktop version as yours. I would suggest you click on Edit Parameters, check which DBName parameter values is used currently. Also please try to click Refresh button. 

 

w3.PNG

 

Best Regards<

Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info