Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Help regarding Parameters for changing Data Sources

Hello, I have created report which is connected to dev environment but now I want to point the report to test environment. Both dev and test are present on same server but in different schemas. How ...
Need Help
LivioLanzo's avatar
LivioLanzo
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Anonymous - did you update the M code and link it to the parameter ?

  • LivioLanzo's avatar
    LivioLanzo
    Icon for Solution Sage rankSolution Sage
    7 years ago

    Instead of using "emp" you'd use the parameter name

     

    let
    Source = Odbc.DataSource("dsn=Dev", [HierarchicalNavigation=true]),
    IMPALA_Database = Source{[Name="IMPALA",Kind="Database"]}[Data],
    emp_Schema = IMPALA_Database{[Name=parameterName,Kind="Schema"]}[Data],
    employee_Table = emp_Schema{[Name="employee",Kind="Table"]}[Data]
    in
    employee_Table

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi LivioLanzo

     

    No I havent. I am bit confused how to edit the M code and to link the parameter.  Below is the M code for the table:

     

    let
    Source = Odbc.DataSource("dsn=Dev", [HierarchicalNavigation=true]),
    IMPALA_Database = Source{[Name="IMPALA",Kind="Database"]}[Data],
    emp_Schema = IMPALA_Database{[Name="emp",Kind="Schema"]}[Data],
    employee_Table = emp_Schema{[Name="employee",Kind="Table"]}[Data]
    in
    employee_Table