Forum Discussion

clarked's avatar
clarked
Regular Visitor
5 years ago
Solved

request time out when entering Oracle data source credentials

Setting up new Power BI server   When I enter my credentials on the data source for a report I'm getting the error: "Couldn't connect The report server couldn't connect to the data source usin...
Data Source
oracle
time out
  • josef78's avatar
    josef78
    5 years ago

    If you are using "Oracle Database" connector, which using ODP.NET part of Oracle Data Access Conectors, check if you have set OS level enviroment "TNS_ADMIN" pointing to folder where you have stored tnsnames.ora. 

     

    You can also install Power BI Desktop RS on server where you have installed Power BI Report Server, and check if problem is between Server and Desktop installation, or it this machine level issue.

josef78's avatar
josef78
Memorable Member
5 years ago

If you are using "Oracle Database" connector, which using ODP.NET part of Oracle Data Access Conectors, check if you have set OS level enviroment "TNS_ADMIN" pointing to folder where you have stored tnsnames.ora. 

 

You can also install Power BI Desktop RS on server where you have installed Power BI Report Server, and check if problem is between Server and Desktop installation, or it this machine level issue.

clarked's avatar
clarked
Regular Visitor
5 years ago

I did have to add tns_admin manually and got it connected. Thanks!