Forum Discussion
Shape Multiple Queries at once
I just tested this and it worked fine for me:
1. Navigate to the "Edit Queries" section (same drop down as "data source settings") and open the Query Editor window.
2. You should see Source and Navigation in right pane. Under the Source step, it should look something like this (a table with the workbook information), see below:
3. In the Navigation step, you can change the values to the new worksheet like below:
4. Close & Apply the steps.
Hope this helps,
Alan
Hey jdata,
If you are working in PBI Desktop, then you can manipulate one of the datasets, then duplicate it and just change the "Source" step to the next query.
Hope this helps,
Alan
Thanks alanhodgson. This sounds like a good solution. But how can I change the "source"?
In this case the new "source" would be another worksheet in the same excel workbook (as I try to heroiclly figure this out, but fail: when i go to "data source settings" I only see the ability to change workbooks, not worksheets). Thanks again.
Jonathan
I just tested this and it worked fine for me:
1. Navigate to the "Edit Queries" section (same drop down as "data source settings") and open the Query Editor window.
2. You should see Source and Navigation in right pane. Under the Source step, it should look something like this (a table with the workbook information), see below:
3. In the Navigation step, you can change the values to the new worksheet like below:
4. Close & Apply the steps.
Hope this helps,
Alan
Got it. Thanks alanhodgson!
Check out this article: http://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/
