Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!