Forum Discussion
Parameter Selection through Buttons or DropDowns
Oh i get what you need, but i don't think there is any way to pass parameters from a visual to a power query request.
Why not retrieving all the data from every different server at once and then filter it to see only the data from a specific server/database ?
Hi t-taaror,
I'm not 100% sure but i think thats what you want to do :
You have two tables (or more) with an identical shema (let say Table1 and Table2 as shown below)
1. Go to merge queries
2. Append Queries
3. Choose the tables you need to append
4. You shall obtain this result
If needed, you can add a column "origin" to Table1 and Table2 to know where each line in Append1 comes from (if you dont know how to do so just ask).
You can also append more than two tables, its not very different from what i explained there.
Hope this helps,
Regards,
Etienne
Hi Anonymous
I am using Direct Query and i don't Want to merge the tables into one table or one visual. Its like there is a set of visuals showing data from one server. I want to have a menu so that i can select the second sever and the parameters change automatically(Like Server Source Name, Database etc.). By doing this i need not to create different reports for each server.
Oh i get what you need, but i don't think there is any way to pass parameters from a visual to a power query request.
Why not retrieving all the data from every different server at once and then filter it to see only the data from a specific server/database ?
Maybe i'll have to stick with that only :smileyhappy: . Thanks for your help Anonymous .
You're welcome, I'm sorry I couldn't do more :smileywink: