Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
M_nwadibia
Resolver III
Resolver III

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

 

3 ACCEPTED SOLUTIONS
d_gosbell
Super User
Super User

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.

View solution in original post

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

View solution in original post

M_nwadibia
Resolver III
Resolver III

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.

View solution in original post

3 REPLIES 3
M_nwadibia
Resolver III
Resolver III

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
Super User
Super User

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.