Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Parameter to switch between source queries

Hi,   I have two source queries containing the exact same data.   I have 10+ reference queries, currently referencing one of the above.   I created a parameter that can switch between the two s...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago
Thanks Jimmy, but as stated in my original post, only one of my sources is a SQL db, the other is an Azure Table Store. So that is why I need a parameter to switch between those two source queries regardless of the original sorce type. Hope it makes more sense now.
v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi RSK,

 

So your requirement is to change data source within different data connectors, right? Query parameter can't switch from one data connector to another, to change data connector, you should click "Get Data"-> "Azure Table Storage". After that, you can use query parameter to select connection info(e.g.: servername, instancename, web url, header).

 

Regards,

Jimmy Tao

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Yes I know how to swith connector manually, but I want from my referenced query, to be able to switch between two different source queries using a parameter, regardsless of those two source queries connecting to two different source-types (SQL and Azure Table) initially.

     

    Is it not possible to parameterize which source query a referenced query is pointing at?

     

    Thanks, and sorry if I am not making myself clear.