Connectivity

Oracle TNS error (ORA-12154 / ORA-12514 / ORA-12541)

Error code: oracle-tns

Power BI dataset refresh error — what it means and how to fix it.

What this means

Oracle TNS errors (ORA-12154/12514/12541/12170/12504): a bad connect identifier, or the listener/port is down or firewalled.

How to fix it

Verify the tnsnames connect descriptor.
Confirm the listener and port are reachable.
Install the Oracle client on the gateway and test in Power BI Desktop.

View on Microsoft Learn

Related connectivity errors

DM_GWPipeline_Gateway_DataSourceAccessError
DM_GWPipeline_Gateway_MashupDataAccessError
Login timeout expired
The server was not found or was not accessible (SQL error 40)
Connection denied — Deny Public Network Access (Azure SQL)
The certificate chain was issued by an authority that is not trusted

Catch this automatically

RefreshRadar monitors every Power BI dataset refresh and alerts you the moment one fails — with the likely cause and the fix — so you never hear about a broken refresh from your stakeholders first.

Start free