How can we import data from multiple sql queries returning the same number and type of columns into

[LV6001]

SQL to DAX 

How can we import data from multiple sql queries returning the same number and type of columns into a new table using power bi?
For example i have 10 sql select queries. They return 3 columns Result, Tests, Quantity
I want to create a new table in power bi with columns Result, Tests, Quantity. This new table should be populated from the 3 sql queries

[AntrikshSharma]

@LV6001 Use UNION ALL to combine them first?

[LV6001 · Accepted solution]

Hi @AntrikshSharma Thanks. Coincidently, I saw your Youtube videos today 😊

I will try with Union All 

Another conern would be that each of those queries query on a fact tables with high volume. 

Is there another performant way to get the result of the individual sql queries in the target table.

This might be for later but I also wish to schedule this run/refresh every two weeks

[AntrikshSharma]

@LV6001 You can create a View that stores all queries. You can also try to create a materialized/indexed view as well.

CREATE SCHEMA PowerBI
GO

CREATE VIEW PowerBI.CombinedSales
AS
	SELECT * 
	FROM FactSales1
		UNION ALL
	SELECT * 
	FROM FactSales2
		UNION ALL
	SELECT * 
	FROM FactSales3

 https://www.sqlshack.com/sql-server-indexed-views/

[LV6001]

Thank you  @AntrikshSharma !!

I am able to achieve the required using UNION ALL 

I am now trying to schedule a refresh on the report server