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.
PowerBI Data connector is not working
Hi Team, The data connector is working for all the other dashboard, but this is notworking for only one dashboard. Find the details are below. Something went wrong Failed to use the selected gateway. Please make sure the gateway is up and running and try again. Please try again later or contact support. If you contact support, please provide these details.Hide details Something went wrong Failed to use the selected gateway. Please make sure the gateway is up and running and try again. Please try again later or contact support. If you contact support, please provide these details. Activity ID: d8b83ad5-d879-4fdb-8a5d-36c2527c48f5 Request ID: b6dcfd41-94a4-b15c-6f2d-1b0f63de945b Correlation ID: e9189609-bc2b-316b-0de6-bcaee68aa5de Status code: 400 Time: Tue Nov 03 2020 16:27:06 GMT+0530 (India Standard Time) Service version: 13.0.14742.37 Client version: 2011.2.03588-train Cluster URI: https://xxxxxxxxxxxxxxxxxxxx/ This isuue is started from last update. Please help me to solve the issue. Thanks, Arjun
