Power BI Desktop does not resolve parameters for connection settings

[SettlerOfCatan]

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 

@v-shex-msft 

With best regards

SettlerOfCatan

[amitchandak]

@SettlerOfCatan , 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?

[SettlerOfCatan]

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. 😪

[amitchandak · Accepted solution]

@SettlerOfCatan , Are you trying to do what is shared in this video by Guyinacube  - https://www.youtube.com/watch?v=OnaDJkGOmIE ?

[SettlerOfCatan]

exactly!

@amitchandak, thank you very much for helping me fixing the parameter issue! You have solved my problem!