Frequent Visitor
Posts: 7
Registered: ‎02-01-2019

Oracle database connection error in Power BI Report Server - On Premise



I have created a report in Power BI Desktop August 2018 version. The reports read from Oracle Database and the connection is successfull.


I have uploaded the report to an On-Premise Power Bi report server August 2018 version. I want to schedule the data refresh for every 1 hour and when I tried testing the connection, It displays the below error saying "The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit to install the official provider"




The server contains the latest ODAC components including Oracle client 12.2. Also I have added appropriate tnsnames.ORA file in the respective path.


Still could'nt figure what is to be done to resolve the error.


Kindly provide suggestions.