Parameter get data from table data

[chenthil]

 Hi All,

Have created two parameters 1. Server 2. Database 

Would like to create third parameters that should show the data from one of the table column connected using first two parameters settings.  Is it possible now?

[Anonymous · Accepted solution]

Hi @chenthil,

It is possible, but I think you these formula need more parameters to control which table and which column to display.

Sample: formula of sql server database

let
    Source = Sql.Databases(Server){[Name=Database]}[Data]{[Schema="dbo",Item=Table]}[Data][Column]
in
    Source

Bold part of above formula is needed parameters.

Regards,

Xiaoxin Sheng

[BhaveshPatel]

Hi @chenthil

Please refer to the below community post. This might help you out to achieve the possible outcome.

https://community.powerbi.com/t5/Desktop/Dynamic-parameter-value/m-p/226114

Thanks,

Bhavexh