parameters values not reflecting accurately in data source settings

[vkodukulla]

We are trying to connect to sql server and postgres database from PowerBI. We parameterize the server and database connection for both the connections, which means we have 4 parameters with each 2 parameters carrying server name and database name. While using these parameters in define the data source settings, a new connection is getting created with part of parameter name. 

We reached out to the support team and PD team and we were told that using "text" as the parameter type is causing the problem. Then we changed parameter type to "Any" and even then we are facing the issue. 

Did anyone faced this issue?

[Anonymous · Accepted solution]

Hi @vkodukulla 

I have a test to connect to SQL Server by parameter, I can see Server name and database.

Result:

Please download the latest verison desktop and try again.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.