Paginated Reports

[KenH_1]

I have a number of Paginated Reports, cobverted from SSRS RDL files. Each is set up in a premium workpsace and use an On Premise Gateway.

Each report is created and published by a pro licence user.

When a user loads the report, sometimes it loads first time and sometimes you have to refresh the browser, but in every case, if you change a report parameter and click  the view report button, every user is presented with an error message as below

Unable to render paginated report

Could not connect to the data source.

If you contact support, please provide these details.

• Timestamp (UTC)2022-08-23T16:28:44.135Z
• Root Activity ID4e42f88d-b3ad-1d75-0587-829afcd7c3e9
• Session ID00003db05abc44778365716d4961d59e
• Tenant ID94cfddbc-0627-494a-ad7a-29aea3aea832
• Cluster URIhttps://wabi-us-north-central-d-primary-redirect.analysis.windows.net/
• Report ID30315b9a-0435-4886-a29c-9567e416f869
• Viewer version2022.8.3.2849

How can this be resolved?

[v-rongtiep-msft]

Hi @KenH_1 ,

I have found a similar post, please refer to it to see if it helps you.

Solved: Re: Unable to render paginated report - Microsoft Power BI Community

• please check if the points in this Troubleshooting article helps.
• In this article https://docs.microsoft.com/en-us/power-bi/guidance/report-paginated-data-retrieval is mentioned that complex data is not avaible to extract by pbi gateway.

If I have misunderstand your meaning, please provide more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @KenH_1 

What happens if you create a report without a parameter does it successfully work?

You might have to troubleshoot it by adding items to the report until if fails

[GilbertQ]

Hi @KenH_1 

Does this happen for all paginated reports or just one paginated report?

The reason that I am asking is because if it is in one paginated report then there might be an issue with the way the report parameter and associated data source is configured?

Does the paginated report run successfully in the Power BI report builder?

[KenH_1]

Hi @GilbertQ , thanks for the quick response. It happens with all the paginated reports we have currently published.

All of them run successfully in report builder.

If you have any ideas on how to fix it, i am all ears.

Thanks

Ken_H1

[bradsy · Accepted solution]

For the reports, make sure all the data sources are configured with a good gateway connection.

You can also check the gateway logs. They might have some information that is useful to help figure out why the reports do not connect to the data source.

[KenH_1]

after checking with our gateway admins, it turns out it was a gateway issue. 

Thanks to all who responded