Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

Cannot Connect to Oracle Database

Hello everyone,

I'm quite new to Power BI and I'm working on a report and need to take data from an Oracle Database. I've downlaoded the Oracle Client for Microsoft Tools and installed it, but when I try to connect to the database on Power BI, I get the following error.


I've not been able to find solutions for this. Any help is appreciated.

Community Support
Community Support

Hi @MajedAK 


The error message "ORA-12541: TNS:no listener" typically indicates that Power BI cannot establish communication with the Oracle Listener when attempting to connect to an Oracle Database. This issue can be caused by several different factors:


  1. Listener Not Running: Ensure that the listener on the Oracle Database is running. You can check the status of the listener using Oracle's  'lsnrctl' command-line tool. If the listener is not running, it needs to be started.

  2. Network Issues: Confirm that your computer can access the server hosting the Oracle Database. There might be network connectivity issues, such as firewalls or incorrect network configurations, that are preventing the connection.

  3. Configuration Issues: Check the configuration of the 'tnsnames.ora' and 'listener.ora'  files. These files are located in the 'NETWORK/ADMIN' folder within your Oracle installation directory. Ensure that these configuration files correctly define the database service and that the listening port (usually 1521) is correct.

  4. Service Name: The service name entered in Power BI needs to match the service name defined in the 'tnsnames.ora' file. Make sure you are using the correct service name in your connection string.

  5. Port Number: Ensure that the port number used by the Oracle Listener (default is 1521) is open on the server and not blocked by a firewall.

  6. Oracle Client Version: Check if the version of the Oracle Client installed is compatible with the version of your database. Sometimes, incompatibility in versions can lead to connection issues.

If you are not the administrator of the database server, you may need to contact the administrator for assistance with this issue. The administrator can check the status of the listener, ensure that the network settings are correct, and that there are no firewalls or other network security tools blocking the connection.




Best Regards,



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

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors