Forum Discussion
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...
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
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?