Import Data With UNION Join in SQL

Hi n Hello   I am trying to Import Data into PBI using an SQL with UNION join  (sample below)   Select col1, Col2, sum(Col3) from table1 group bt col1, col2 UNION Select col1, Col2, sum(Col3) f...