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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
v-rongtiep-msft
Community Support
Community Support

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
v-rongtiep-msft
Community Support
Community Support

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.