Changing the Database Names in Edit Parameters

[Byzbkr]

Hi,

I have multiple databases in my server and all of the tables are the same in those databases. I designed my report for a specific database and I am changing the datasource with parameters. When I click edit parameters; I am choosing server and database names. But I dont want to see db names in drop-down. I have seperate table and in that table I have db names in one column and other column includes the names that I want to see in drop-down. Is there a way to do that? Thank for your helps in advance.

[Anonymous]

Hi @Byzbkr ,

You can refer the following links to get it by creating parameter table.

Create A Parameter Table For Your Power Queries

Create parameter table Create function

Apply the parameter in the source

---

Parameter Tables in Power BI / Power Query

Best Regards

[amitchandak]

@Byzbkr , Under manage parameter. In the suggested value option. You have an option for the query. Choose on of the table /query there

[Byzbkr]

Thanks. But with this option we can just create list with the existing database names. For example,  our SQL database name is "1234_2021" but while I am choosing my database name in parameters pane from the list I want to see "Apple" instead of "1234_2021". How can I do that in query? Can you give me an example query for that issue?