Executing Two Queries with F5

[M_nwadibia]

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

[d_gosbell · Accepted solution]

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.

[M_nwadibia · Accepted solution]

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

[M_nwadibia · Accepted solution]

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.

[d_gosbell · Accepted solution]

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.

[M_nwadibia · Accepted solution]

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