Forum Discussion

vkodukulla's avatar
vkodukulla
New Member
4 years ago
Solved

parameters values not reflecting accurately in data source settings

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's avatar
    Anonymous
    4 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.