How to build Power BI report by converting SQL query to Power BI steps.

Hi All,

I have query which  need to convert into Power BI.I can't use SQL as connection.

Below is the example of query:

SELECT ColumnA,ColumnB
FROM table1
left outer join table2 ON X=Y
INNER JOIN table4 ON A=B
LEFT OUTER JOIN table3 on C=D
WHERE ColumnZ IN (1,2,3) AND ColumnD=0

UNION ALL

SELECT ColumnX,ColumnY
FROM table1
left outer join table2 ON X=Y
INNER JOIN table1 ON A=B
LEFT OUTER JOIN table3 on C=D
WHERE ColumnZ IN (1,2,3) AND ColumnD=0
and ColumnH = 0 and ColumnD <>5 and ColumnV = 1

UNION ALL

SELECT ColumnX,ColumnY
FROM table10
left outer join table20 ON X=Y
INNER JOIN table40 ON A=B
LEFT OUTER JOIN table30 on C=D
WHERE ColumnZ0 IN (1,2,3) AND ColumnD0=0
and ColumnH0 = 0 and ColumnD0 <>5 and ColumnV0 = 1

Please suggest any way to implement this in Power BI.