Forum Discussion

angeloola's avatar
angeloola
Icon for Helper I rankHelper I
7 years ago
Solved

Use parameter to change data connection types (e.g. Denodo to SQL Server)

So, I've seen tutorials that show how to use parameters to switch between server instances or databases on a server, or to change Excel file paths. They are always using the same source TYPE, however...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi angeloola ,

    Based on my test, you could refer to below code in query editor with if parameters:

    With my sample, I uesed two excel files, you could switch one to your sql query.

     

    Regards,

    Daniel He

     

angeloola's avatar
angeloola
Icon for Helper I rankHelper I
7 years ago

That's awesome! Thanks v-danhe-msft ! Can I specify my sources in that parameter using a list (e.g. "SQL" "Denodo"? Or, does it only work with a number?