Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
Setting up new Power BI server
When I enter my credentials on the data source for a report I'm getting the error:
The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.
Connection request timed out"
It works fine in desktop with the same credentials.
I did install the 64 bit Oracle data connectors on the server but don't know how to test if it was successful. Also updated tnsnames file with the version we use for everything else.
Connection string is the standard:
data source=instance_name;persist security info=True
Solved! Go to Solution.
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.
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.
I did have to add tns_admin manually and got it connected. Thanks!
use SQLPlus to test the connection.
What do you mean by Power BI Server ? Report Server or Gateway?
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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 1 |