Paginated Reports with Oracle DB Connection Type
Greetings, I am using Power BI Report Builder to generate a report using Oracle DB as the connection type. It runs fine on my local machine, but when published to the server I get the displayed error when trying to access it. The "Additional steps are required to view this report" link brings me this this page Power BI gateway and Report Builder support for ODBC data sources (preview) - Power BI | Microsoft Docs , which outlines how to configure and use ODBC with paginated reports. We have explored and configured this option, but it does not perform as well as the Oracle DB connection type when connected to our Oracle database. So far we have confirmed the 64 bit ODAC 12.2 is installed on the host server, following the instrutions here [Oracle Connection Type (SSRS & Power BI Report Server) - SQL Server Reporting Services (SSRS) | Microsoft Docs ]to register the ODP.NET Managed Client to both the GAC and machine.config. We have Power BI reports that use the existing Oracle connection just fine on the server, so not sure what next to try in resolving this. Any help will be apreciated, and should more details be required I will provide.
