Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI Desktop does not resolve parameters for connection settings

Hello everybody,

 

I have received a local Power BI Report from my client. The work on the report is completed.

The last task which needs to be accomplished is to set the data source settings by using parameters.

 

Therefore, I created two parameters:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Then, I went into the data source settings in order to use these two parameters.

 

I choose "Change Source":

I am using the parameters for the data source:

And this is the result:

 

As you can see, Power BI Desktop is using the name of the parameter instead of its value (DatabseValue).

 

I went back to the data source settings and set the parameter "ServerName" in both fields.

This is the result:

 

 

 

 

 

 

 

 

 

 

 

 

 

Again, the value for the server is correct but the value of the database could not be resolved.
Instead, the name of the used parameter shows up instead of its value.

 

I noticed that this behaviour does not appear in new/unedited Power BI Desktop files, but in Power BI Desktop files that have already set up a (working) data source connection.

 

How can I set these parameters even under these circumstances with Power BI Desktop?

Can someone confirm this behaviour of Power BI Desktop?

 

My client is using the RS version of Power BI Desktop (May 2021).

 

I appreciate any help to solve this issue.

 

v-yingjl 

Anonymous 

 

With best regards

SettlerOfCatan

Need Help
Show and Tell

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , I think when you open and check advance editor(of a table) , there you should see the difference(Parameter name replaced with actual value).

    Are you able to add a table using this connection?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello amitchandak,

       

      Thank you for your reply.

      This is a great idea!

       

      I have opened the advanced editor and this is what I got:

       

       

       

       

       

       

       

       

       

       

      I am sorry for asking this question:

      What do I need to change (properly I need to replace Name="DatabaseName") so that the value of the parameter DatabaseName is being used?

       

      I am not familiar with the M-language. 😪