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
User | Count |
---|---|
13 | |
3 | |
2 | |
2 | |
2 |