Forum Discussion

chenthil's avatar
chenthil
New Member
8 years ago
Solved

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 s...
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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