Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |