Forum Discussion

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
11 months ago

Hi yaman123,

The official documentation states that the ORA-12154 error happens when the Oracle alias can't be resolved, often because tnsnames.ora is missing or set up incorrectly. It recommends confirming that the 64-bit Oracle Client for Microsoft Tools (OCMT) is installed on the Gateway machine and that the alias is properly configured in tnsnames.ora. The documentation also suggests testing the connection through Power BI Desktop on the Gateway machine to make sure everything is set up correctly.

Manage your data source - Oracle - Power BI | Microsoft Learn

Power Query Oracle database connector - Power Query | Microsoft Learn

 

Thank you.

yaman123's avatar
yaman123
Post Partisan
11 months ago

Nothing has changed in tnsnames or oracle db connections. The issue all of a sudden appeared yesterday around 10am UK time. From previous posts, this could be due to the Sept update.