One of my reports is using the name of a database parameter rather than its value

[JasonOuellette]

I created a report, initially by typing in the server and database in "get data". Later I tried changing these to parameters so they could be easily changed. I've done it before and it worked fine. I create the parameters and put in the values I want for them. I change the connectors in "get data" to use the parameters. It correctly pulls the value of the "server" parameter, but when I tell it to pull the value from the "database" parameter, it instead just pulls "database", which is the name of the parameter.

I've tried this on other reports and I don't have the same issue, in a fresh report I can create parameters and it correctly pulls their value for the server and database. On this one report, including old versions of it as well as when a colleague tries to do the same thing, we are having this issue. I've tried changing the type between text or any, and clicking and un-clicking required. We've tried multiple machines.

Is this particular report just bugged? Right now I'm re-creating it from scratch, with parameters as the connection from the start, but re-creating everything is going to be the better part of a days work. Is there any way I can fix this in the existing report, or at the very least prevent it from happening again?

Thanks

[v-chuncz-msft]

@JasonOuellette 

Additionally, take a look at https://docs.microsoft.com/en-us/power-bi/refresh-data#configuring-query-parameters.

[Greg_Deckler · Accepted solution]

Can you share you code from Advanced Editor?