Forum Discussion
Parameter get data from table data
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?
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 SourceBold part of above formula is needed parameters.
Regards,
Xiaoxin Sheng
2 Replies
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
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 SourceBold part of above formula is needed parameters.
Regards,
Xiaoxin Sheng
