SQL Native Union comparable in ODataFeed Native Query

[smpa01]

Hello Experts,

I have used ODataFeed connector for sharepoint lists. The sharepoint I connect to contains 120 lists. Let's suppose for now I have 2 lists each with Title, Index and First Name Column

Now I have used following methods

let
    Source = OData.Feed("https://x.sharepoint.com/teams/Test102/_api/web/lists/GetByTitle('TestList1')/Items?$select=Title, Index, First_x0020_Name"),
    Custom1 = OData.Feed("https://x.sharepoint.com/teams/Test102/_api/web/lists/GetByTitle('TestList2')/Items?$select=Title, Index, First_x0020_Name"),
    Custom2 = Source&Custom1
in
    Custom2

I am geting each list in each  step and then appending together at the end. I was wondering if there is a SQL-like native query exists for ODataFeed where I can append both the tables in the native query before importing into Query Editor

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2; 

Sql Union

If there is a Union I can perform in OdataFeed Native Query the power BI performance is going to improve. I don't want to do the append in M if there is a native UNION exists in ODATA

Thank you in advance.

[v-chuncz-msft]

@smpa01,

You may check the link below.

https://stackoverflow.com/questions/22954807/rest-query-with-two-lists