Getting ODBC error while trying to execute SQL Query while trying to connect with database

[Anonymous]

I have connected to data source and tried to execute direct query some thing like below.

select t1.id,..,..., t2.id,... from table1 t1 JOIN table2 t2 on t1.id = t2.id WHERE t1.id =1

But am unable to execute the query. Power BI throws following error

Unable to connect
We encountered an error. while trying to connect. Details: .ODBC ERROR