Can't import data from ODBC use query

[Henry1943]

I want to import the data in ODBC which was successful used in excel,

and click OK the results come out like 

but when I fill everything done as below

 not all variables bound

I tried many times but still can't work, while the excel could works well

Really appreciate your help!

[v-yulgu-msft]

Hi @Henry1943,

Based on my research, this error appears as if not all of the parameters in your SELECT are bound to columns, or perhaps one of the binds is failing. Please troubleshoot this to ensure that each of the parameters is correctly mapped to source columns, and if they are, to determine which column(s) are failing.

Besides, please test whether the ODBC connector works fine in Power BI desktop via a simple query without any variable.

Regards,
Yuliana Gu

[Henry1943]

Hi Yuliana，

Thank you for your great help, I could connected with the ODBC, and all the tables I could load it when I use the most sample query like "select * from table name" so the problem is I have five or more tables need and I need to compare the colums to do the calculate like the SQL query as below:

"SELECT (SELECT x.vendor_name

                FROM ap.ap_suppliers x,

                          po.po_headers_all pha

             WHERE p.po_header_id = pha.po_header_id

                  AND pha.vendor_id = x.vendor_id) ‘Supplier’,

             p.segment1 ‘PO Number’,

            ``````"

In this query I comepare the same column name in different table and I add "p" or "pha" in the front, for excel, these sentence works, but in Power BI ,I was told that 

DataSource.Error: Oracle: ORA-00904: "P"."PO_HEADER_ID": invalid identifier

So, could you kindly help me with this? how could I compare the same name column in different table by SQL code ?