paginated report
8 TopicsUsers access to paginated reports
Hi, I have created a paganiated report visdual on a report and published to the app. I have given access to the app to serval users and they are unable to see the paganated visdual. They get an error message "Cant display details" and when they click on the see details it says "Sorry we couldnt find that report" "It may have been deleted or you may not have access to it" Anyone have any ideas whats going on? Thanks530Views0likes2CommentsUnable to render paginated report when creating Formatted Table
I am trying to create a Formatted Table from a dataset and getting the following error. Unable to render paginated report. Please try rendering your report again...(see below screenshot). I choose to create a Formatted Table instead of a Paginated Report because the data is too large and the Paginated Report will error in the Report Builder. I am not wanting to create using XMLA. This has worked for multiple other reports but as a yesterday I have not been able to create Formatted Tables.922Views0likes2CommentsPaginated 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.2.5KViews0likes4CommentsCan you call an Oracle Stored from a Published Paginated Report
Hello, I have tried to call an oracle stored procedure returning a sys_refcursor and I am getting the below error. Now if I take the same query and use the same parameters it works fine. I know this is an option, but we are converting around 200 reports from OBIEE to Power BI Paginated Reports. I looked online and they are saying it is not possible to call an oracle stored procedure from a published paginated report. I need to know if this is true or is there a work around. Unable to render paginated report Data for this report could not be loaded due to an on-premises gateway error. A query in this report may be returning a field which is not supported by the on-premises gateway. Please remove any fields containing user-defined types or unsupported gateway types and try again.Solved1.5KViews0likes3CommentsData Source Credentials Option Greyed Out for ODBC Connection (Denodo)
Hi Community, I am using 32 bit ODBC DSN to Connect Report builder to Denodo. I have Created Paginated Report using Configured 32 bit ODBC DSN and Report is working fine in Report Builder but when i published same report, it is not working in Power BI Service. "Unable to render paginated report A data source used by this report returned an error. An exception encountered while accessing the target data source ERROR [08001] ERROR: SSL connection required ERROR: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. DETAIL: java.sql.SQLException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version." Also Data source Credentials option got grayed out. what is the possibe reason and how can i resolve the issue? Thanks, PravinSolved5.6KViews0likes4CommentsPaginated Report Error
Hi, I have 2 Paginated reports in a Premium Workspace and the admin has allocated 30% of the workload to Paginted report, still, I keep getting the error that enough resources have not been allocated to render the report. The premium node is a P2 16v core type. Any ideas or suggestion on how I can solve this particular issue.960Views0likes2Comments