Power BI Report Server with Oracle data source

• wayne.l.dueck

  SSC Veteran

  Points: 278

  More actions

  July 19, 2023 at 4:28 pm

  #4239298

  We have an Oracle data source configured in Power BI Report Server. We have the Oracle 19c Client installed and configured. We used information from the Microsoft website to configure the server.

  Works great for a while but then we start receiving the following error when running a report using the Oracle data source -

  “ORA-12154: TNS:could not resolve the connect identifier specified”

  A quick google of the error brings up pages on how to resolve the error but those things are already done and were working. I check the environment variable, the tnsnames.ora file is correct and I don’t see any errors in the report servers’ log files.

  While we are receiving this error in the Report Servers’ web page, we run an Oracle utility that installed with the client and it checks the configuration and successfully connects to the Oracle database.

  Restarting the Power BI Report Server service resolves the issue for a while, but within a day or two (depending on usage?) we start getting the error again.

  Any ideas on how to resolve this issue?

  Thanks

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 20, 2023 at 5:06 pm

  #4240276

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.