Forum Discussion
clarked
5 years agoRegular Visitor
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...
- 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.
lbendlin
5 years agoSuper User
use SQLPlus to test the connection.
What do you mean by Power BI Server ? Report Server or Gateway?
- clarked5 years agoRegular Visitor
Strangely enough after adding tns_admin env variable it didn't work until I connected once via sqlplus. Now working, thanks for the help. Was for Power BI Server