Paginated Report
Hello everyone, I have a Paginated Report that works just fine on the Desktop App but if i publish the report to the powerbi Service and want to use it, i get the error message, "Unable to render paginated report A data source used by this report returned an error. Received error payload from gateway service with ID 57703: Async operation a1ee1d60-b03b-4159-b802-8d902e4eef69 is faulted with [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.AdomdDataAccessErrorResponseException: AdomdException encountered while accessing the target data source. GatewayPipelineErrorCode=DM_GWPipeline_Gateway_DataSourceAccessError GatewayVersion=3000.242.9 ErrorCode=-1056308850 ---> [1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: AdomdErrorResponseException:The specified query is too complex to be evaluated as a single statement. GatewayPipelineErrorCode=DM_GWPipeline_UnknownError GatewayVersion=3000.242.9 InnerType=AdomdErrorResponseException InnerMessage=The specified query is too complex to be evaluated as a single statement. InnerToString=Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The specified query is too complex to be evaluated as a single statement. " I get the error message when i select my filters and then click on view report. If i want to get only one customer at the filter the reports works but when i want to see all customers at one i get the error. In the Desktop App "Power BI Report Builder" i dont get this issue at all. How can i resolve this error? Any suggestions?
HTTPS ERROR POWER BI REPORT SERVER
Colegas alquien que me pueda ayudar, Recientemente reinstale un servidor PBIRS por que la base de datos se contraba corrupta, segui los pasos en el foro para dicha reinstalacion, ahora veo que el sitio con el puerto 80 funciona, puedo organizar mis carpeta, asignar usuarios, ver informes BI, etc. Sin embargo al usar el puerto 443, puedo realizar todo ello excepto visualizar informes BI. Antes no me pasaba eso, sin embargo el servidor anterior yo no lo configure. Revise mi configuracion en report server configuration manager y al parecer todo esta bien. ¿es necesario realizar mas configuraciones en los archivos .config? esta parte aun lo lo revise. Mi version de septiembre 2025Add context url to powerbi endpoint
Hello everyone, I asked a similar question a couple months ago but after testing out some options we are still on an empasse. Basically what we are trying to achieve is add a context url to each Report Server - Power BI virtual directory. Those are: /Reports /ReportServer /powerbi Through the use of an apache server, we managed to add the context we need in front of /Reports and /Reportserver, re-writing urls to /omr/Reports and /omr/ReportServer. We still have problems with the third virtual directory, which is /powerbi. What happens when you navigate to any dashboard inside a Report Server is that internally, the Web Page of the Report Server calls /powerbi endpoints to retrieve the corresponding data. The problem is that we need that endpoint to be rewritten to /omr/powerbi, but we cant do that server side. We need to have a way to change it in the fetch operation, when the request is sent. Is there any possibility to do this?
