Error : "Oracle: ORA-00918: column ambiguously defined" , power bi

[Anonymous]

 Hi,

I am getting "Oracle: ORA-00918: column ambiguously defined" error while loading data using the Direct Query option from the Oracle database to Power BI desktop. 

When I am running the same SQL query in Oracle Database, it is working fine. I am having this issue while loading the data to Power BI. Please let me know how to resolve this issue.

Thank you!

Aswini C S.

[Anonymous · Accepted solution]

Resolved the error

ORA-00918 error occured while joining two or more tables that have the same column name across different tables.

 Added the prefix to each column with the table name that it originally belonged to and then tried loading the data using that SQL command with Direct Query Option and it worked.

Please find the below link for more details on how to resolve this issue.

tekstream.com/resource-center/ora-00918-column-ambiguously-defined/

[dax]

Hi @Anonymous , 

It seems that you solved this problem, roght? If so and if you'd like to, you could mark corresponding post as answer or share your solutions. That way, people who in this forum and have similar issue will benefit from it.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.