Forum Discussion
Excel OData: Multiple Queries from Multiple Sources
Hello, I was hoping someone might be able to tell me if it is possible to build a set of queries, loaded to tables in Excel, from a list of sources. I;'ve worked with single parameters before (lik...
Hi Anonymous ,
Technically it's possible. You would essentially just replace the references in the Source/Navigation steps to a position in your list.
So, references to 'THIS_IS_MY_DATA_1' would become 'LIST OF DATA SOURCES'{0}.
There will be other intricacies to getting this to work exactly as required (for example, error handling queries that reference a list position beyond the length of your source list etc.), but this is the principle of the method.
Pete