Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change data source for visuals

How do I change the data source which is feeding a visual? To clarify, I've learned how to do this:   I have visual1 and datasource1 and datasource2. visual1 uses datasource1, so I go into datasour...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    If you can confirm these query tables has same data structure, you can try to parametrize these query tables' connection string as query parameters.

     

    After above operations, you can simply switch datasource by edit on 'query parameter' and 'apply change' to load new data from different data sources.

     

    Before change:
    visual A -> table1 -> datasource 1 ->connection string parameter 1
    visual B -> table2 -> datasource 2 ->connection string paramerter 2

     

    Modify parameters:

    visual A -> table1 -> data source 2 -> connection string parameter 2
    visual B -> table2 -> datasource 1 -> connection srtring paramerter 1

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

If you can confirm these query tables has same data structure, you can try to parametrize these query tables' connection string as query parameters.

 

After above operations, you can simply switch datasource by edit on 'query parameter' and 'apply change' to load new data from different data sources.

 

Before change:
visual A -> table1 -> datasource 1 ->connection string parameter 1
visual B -> table2 -> datasource 2 ->connection string paramerter 2

 

Modify parameters:

visual A -> table1 -> data source 2 -> connection string parameter 2
visual B -> table2 -> datasource 1 -> connection srtring paramerter 1

 

Regards,

Xiaoxin Sheng