Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Paginate Reports - Data retrieval failed for subreport

As of yesterday, intermittently we are getting the error in paginated reports "Data retrieval failed for subreport" in the Power BI Service.   This is very frustrating as it is random, can happen f...
Need Help
AbhiSSRS's avatar
AbhiSSRS
Icon for Solution Sage rankSolution Sage
5 years ago

Hello!

 

Could you please give some more information here. Is th subreport accessing an On-prem data source or a Power Bi Service Dataset in Live connection? 

We can diagnose these sub report issues by only 1 way... You would need to install Power Bi report Server on-prem and then deploy this rdl to the server ... Then running it would create a detailed log in your reportServer folders and they point exactly to the reason (timeout, parameter or any other issue) 

Also you may try to run profiler against your data source if that is SQL or Live Power BI dataset (refer article below for profiler)

https://www.linkedin.com/pulse/run-profiler-power-bi-live-datasets-paginated-reports-abhinav-singh/