Unable to render paginated report – Power Bi

Unable to render paginated report: The above error seems to be from probably a service error in Power Bi and This error occurs when you try to open an RDL or paginated report in Power Bi Service with associated data source such as SQL, azure SQL, analysis services, azure analytics Etc.

In this article we will see multiple steps or action to be taken to resolve this particular issue, please follow all the troubleshooting steps to make this work. Will see three different methods on how to overcome through this issue so if you’re looking at this article then make sure you have power bi admin access and the data source as so that we can make some changes to overcome this issue.

Error/Issue

Data for this report could not be fetched in the allocated time. If you continue to experience this error, contact the report author or data source owner to increase the time-out.
Unable to render paginated report
A data source used by this report returned an error. If you continue to experience this error, contact the report author or data source owner quoting. Timeout occurred after 615 seconds while attempting to execute the query. Please ensure your query can complete in the allowed time. The operation is timed out.

Unable to render paginated report Troubleshooting

Method 1:

Open the report in Microsoft report builder or power bi report builder and test the behavior.

I could see that when I tried to fetch data from my Analysis Services even, I was getting the same error. I have found that I was trying to import the data in wrong way so could you please follow the below steps to fetch data from Synapse Services/Analysis services into your report.

Step 1: Try to create the new report by connecting to same data source.

Step 2:  As you can see when I try to import data, I am importing the table within the model, the yellow highlighted are the columns where the data is present, instead of selecting the whole dimension (tblactor) I am selecting the Actorid, ActorGender & castID columns.

1
Once done please re-upload the report to power bi service and check whether it is working or not?

Method 2:

In the report builder if you see the data source properties and check the “connection time out” is by default will be 15 second. Now we will change the default value to some other time and check the behavior. In my case I am changing the value to 100 seconds.

Note: The time interval in “connection time out” is measured in “Seconds”. So, enter the value accordingly.

2
Go to Data Source >> Build >> Advanced >> Under this scroll down and you will find “connection time out.”

Method 3:

Increase the time out value for datasets in the report side. Now if you browse this below article, you can see that if the time is set to 0 then it can have infinite number of time interval, but it doesn’t apply all the time when it comes to paginated/rdl report in power bi service.

For Info: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/setting-time-out-values-for-report-and-shared-dataset-processing-ssrs?view=sql-server-ver16

image
In my case I have only one dataset, suppose if you have multiple datasets coming from different sources then you have to increase out for all different “Time out” (in seconds)

Note: when you have “0” as time out in dataset i.e., infinite time out value. It does not apply to power bi service when your Data Source is associated to Gateway because Gateway time out value is about 600 seconds. For more information you can see this below article.

Information about gateway timeout and more: Set time-out values for Power BI paginated report dataset processing – Power BI | Microsoft Learn

Method 4:

If your report is really too complex or have more no of record trying to pull in the report, then probably it is long running queries. We will not deep dive into that because we need to collect SQL Profiler for more information. For time being we can just increase for testing purpose and check he behavior of the report in power bi service.

image 1

SQL Bi Links:

  1. Kerberos Issue: NT AuthorityAnonymous Login Failed -Resolve (kingfishertechtips.in)
  2. Port Number For Analysis Services – Find Ports For SSAS? (kingfishertechtips.in)
  3. RS.exe Utility: Migrate RDL Reports To Another SSRS/PBIRS (kingfishertechtips.in)
  4. Direct Query Mode ON In Tabular Model Issue – Visual Studio (kingfishertechtips.in)
  5. SMTP Server In SSRS/PBIRS |Subscribe To Email Problem/Issue (kingfishertechtips.in)
  6. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  7. Creating Tabular Project & Deploy Model To Analysis Service (kingfishertechtips.in)
  8. Deploy Tabular Project To Azure Analysis Service – SSDT Tool (kingfishertechtips.in)
  9. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  10. Could Not Load Folder Contents In Portal URLs – SSRSPBIRS (kingfishertechtips.in)
  11. SSRS/PBIRS – Install And Configure The Report Server On-Prem (kingfishertechtips.in)
  12. SQL Server 2022 Download, Install, Connect Using SSMS Tool (kingfishertechtips.in)
  13. Capture Fiddler Trace for Debugging the Network Traffic (kingfishertechtips.in)
  14. On-Premises Gateway: Configure/Map SQL DB To Power Bi (kingfishertechtips.in)
  15. Fixed Column/Row Header Make Visible In Any Report (kingfishertechtips.in)
  16. Self-Signed Certificate: Configure SSRS/PBIRS With SSL (kingfishertechtips.in)
  17. Create Local User Account/Local Admin User In Windows 10/11 (kingfishertechtips.in)
  18. Login With AAD/Domain/Microsoft Account To Azure VM’s/RDP (kingfishertechtips.in)
Vickey Rajpoot
Vickey Rajpoot

Hello there! I'm dedicated Microsoft Data & AI Engineer at LTIMindtree, where I thrive technology into actionable insights. Dive into my world by visiting my YouTube channel & Webiste, "Kingfisher Tech Tips".

Articles: 71

Leave a Reply

Your email address will not be published. Required fields are marked *