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?Can't schedule refresh for this dataset in Power BI service
I used a Python script in Power Query to pull data from Prometheus. It works fine in PBI Desktop, but I get the following error for the automated refresh in the Power BI service: Unable to determine the data source due to unknown functions. When custom connectors are used, the error can happen if gateway doesn't have the extension enabled. Details: Query contains unknown function name: Python.Execute. Data source for Query1 Discover Data Sources. How can I solve this error? Can I use Vnet as a solution for this?
The requested session was not found, Paginated reports
As we are using, Premium Per Capacity and report was working fine till yesterday. Suddenly, paginated reports are throwing error "The requested session was not found. It may have expired, or was cancelled". Power BI reports are working fine, only issue on paginated. If we run rdl in local, it is working perfectly, only on power bi service getting this issue from today. Please help me out of this issue. Attached snapshot for reference.
Password protected Access Database - Gateway error
Hi all, I am fairly new to Power BI. I have an access database which is password protected. From my Power BI Desktop, I am able to successfully connect to it through OLE DB driver (Thanks to reference). Now, I have published the report online and trying to schedule a refresh for this database through an on-premises gateway (reference) located in the server. I tried choosing couple of Authentication Methods and still hitting the following roadblocks. Windows - OLEDB driver does not support this authentication method Anonymous Any leads would be appreciated, thanks in advance.
