Creating Data Tables for Multiple SQL Outputs within 1 Query

[Grove]

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

[Anonymous · Accepted solution]

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.