Forum Discussion

im_newbie_123's avatar
im_newbie_123
Frequent Visitor
6 years ago

Use advanced power query editor to use SQL statement

I have a sql statement which is union of two tables.

 

I want to use the sql statement inside advaced query editor.

 

My SQL Statement :

SELECT [ABC],[XYZ] FROM TABLE1
UNION
SELECT [PQR],[YAA] FROM TABLE2

 

I have to create something similar to a view which will have union of these two tables along with a new name for the dataset.

Need Help

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    6 years ago

    Hi im_newbie_123 ,

     

    In power query, we should rename the column [PQR],[YAA] in table2 to  [ABC],[XYZ], then we can append the tables to get a excepted table.

     

    Btw, we can enter the sql statement when we connect to the database in power bi desktop.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    As I understand you can not do SQL on PowerQuery but you can do exactly the same operation with an APPEND of two Queries. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    You could write the SQL in PowerQuery:

    = Table.NestedJoin(#"weekly report", {"Unique ID"}, Tracker, {"Unique ID"}, "Tracker", JoinKind.LeftOuter)