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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Grove
New Member

Creating Data Tables for Multiple SQL Outputs within 1 Query

I want to use just 1 query to create multiple data tables using the multiple outputs. Is this possible? When I run the query in SQL, multiple outputs are generated, is there a way to do the same in power bi? It seems it would be most efficient to run the query once, since subsequent tables use prior temp tables/outputs depend on earlier tables in the query.

 

For example, in the below SQL would create output1 and output2 tables. HJow do I replicate this is power bi? if possible?

 

Thanks

 

IF OBJECT_ID('tempdb..#Output1') IS NOT NULL DROP TABLE #Output1;

select * into #Output1 from data_source

select * from #Output1

 

IF OBJECT_ID('tempdb..#Temp2') IS NOT NULL DROP TABLE #Temp2;

select * into #Temp2 from #Output1

 

IF OBJECT_ID('tempdb..#Output2') IS NOT NULL DROP TABLE #Output2;

select * into #Output2 from #Temp2

select * from #Output2

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Grove ,

It is possible to create multiple data tables from one query in Power BI. You can use the Power Query Editor to merge or append tables based on matching values from one or multiple columns. You can also use different types of joins, such as inner, left outer, right outer, full outer, or cross join, depending on the output you want.

 

Merge queries overview - Power Query | Microsoft Learn

Append queries - Power Query | Microsoft Learn

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Grove ,

It is possible to create multiple data tables from one query in Power BI. You can use the Power Query Editor to merge or append tables based on matching values from one or multiple columns. You can also use different types of joins, such as inner, left outer, right outer, full outer, or cross join, depending on the output you want.

 

Merge queries overview - Power Query | Microsoft Learn

Append queries - Power Query | Microsoft Learn

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.