Power BI Reporting Server Solution
Our client (Company A) and our project team has faced the difficulties below to deploy Power BI Report server solutions. Can you advise how we can get support on that? Company A ’s Requirement: Due to security concerns, users need to get the data in Company A ’s Oracle DB without directly connecting to Company A ’s Oracle DB. Our current solution: First, we create a Data Source connecting to Oracle DB in Power BI Report Server by using ADO.net Connector with SSL (Oracle Wallet). Then, we create a Dataset using the Data Source. And the last, users use Odata Feed connecter in Power BI Desktop/Excel or Postman to connect to the Dataset with Power BI user authentication with Company A's Active Directory. The problems of current solution: Not able to load data into Power BI Desktop/Excel/Postman from Dataset using Odata when the amount of data is large (Timeout occurred), any sizing guide or limitation on this? Not able to create Data Source connecting to Oracle DB by using ADO.net by SSL with Wallet The additional concerns: Limitations of concurrent user capacity Any other solutions could cope with the need required? Thanks for your advice!
Oracle database connection error in Power BI Report Server - On Premise
Hi, 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 https://go.microsoft.com/fwlink/p/?LinkID=272376 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. Thanks, MithraError al actualizar datos - Error updating data
Hola Comunidad, Me aparece el error adjunto cuando hago la actualizacion de mis datos, no se si es un error de la conexion de la puerta de enlace o de la conexion con la data de Oracle. Pero ya he intentado de todo y no funciona. ---------------- Hi Community, I get the attached error when I update my data, I don't know if it is an error in the connection of the gateway or the connection with the Oracle data. But I have already tried everything and it doesn't work. Thanks.ORACLE 19
Hi guys, we are using on-premise PBIRS. We installed ORALCE drivers on the server as described in this documentation: https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15 We used 18.3 version of the driver, because it is what the documentation suggests. All works like charm. Our problem is, we need to use the latest version of the driver, 19.3.1, because that's what we use everywhere else. I tried the above instruction with this version, but the connections to ORACLE end with "connection lost" error. My questions are: Is 19.x version of the drivers supported by Microsoft? If not, when will be the support added? Did anybody of you persuade PBIRS to work with ORACLE 19.x drivers? So far we use paginated reports only, so crucial is to have functional rendering of RDL reports with the latest driver. We do not use OLEDB/ODBC because of various problems - we need ODAC. Thank you, Petr
