Forum Discussion
Paginated Reports
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
Could not connect to the data source.
- 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?
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.
6 Replies
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
Super User
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?
bradsyMicrosoft Employee
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.
