Forum Discussion
Executing Two Queries with F5
Hello,
I have a requirement to exceute two SQL Queries in Query designer.
select * from Table A;
Select * from Table B
The result produces to tables when exported using excel instance
It works in Toad for Oracle but not working in Query designer. What options do I have as I am seeing this the first time
It is not clear whether you are talking about the Query designer in Paginated Report Builder or Power BI Desktop. But either way you cannot execute 2 queries at once.
I'm assuming that these are two individual tables and that you don't want to join them.
If you are building a paginated report you will need to create 2 datasets and put each query in it's own dataset. You can then put two tables in your report and link each one to a different dataset.
If this is a Power BI Desktop report you would have to bring each query in as a separate table and you could then use two separate table visuals.
Yes these are two separate tables. Linking the two dataset using Parameter will it generate two tables when exported in excel.? The requirement is to export the two tables in a single email to the user
What I have done is to create two dataset from the datasource and then have the two dataset reports exported to tab1 and tab2 in excel.
3 Replies
It is not clear whether you are talking about the Query designer in Paginated Report Builder or Power BI Desktop. But either way you cannot execute 2 queries at once.
I'm assuming that these are two individual tables and that you don't want to join them.
If you are building a paginated report you will need to create 2 datasets and put each query in it's own dataset. You can then put two tables in your report and link each one to a different dataset.
If this is a Power BI Desktop report you would have to bring each query in as a separate table and you could then use two separate table visuals.
Yes these are two separate tables. Linking the two dataset using Parameter will it generate two tables when exported in excel.? The requirement is to export the two tables in a single email to the user
What I have done is to create two dataset from the datasource and then have the two dataset reports exported to tab1 and tab2 in excel.