Oracle Tables Loads from Oracle Database, But writing SQL Statement says Table doesnt exsist

[KAD911]

Hello,

 I have a oracle database, and I can connect to the server and load tables from the database when Im using,

Get Data > Oracle Database > Direct Query > OK.
I can see  all the available tables and i can load them to powerBi without a problem.

But, If I goto Advanced Options and write a SQL Statement. (Even a simple SELECT * FROM MY_TABLE), it gives me the Error saying that the TABLE or VIEW Does Not exsist.

Please help me fix this problem,

Thanks,

KAD

[amitchandak · Accepted solution]

@KAD911 , Try to add DB or Schema Name and try

SELECT * FROM DB1.MY_TABLE

[KAD911]

Oh that was it!! 
 I feel so stupid now.

Thanks aloot!! You saved the day!!