Viewing paginated reports in the portal

[GoingIncognito]

Hi

I've published paginated report to the portal. They're obviously on premium capacity and all that. But the problem is with report crashing when parameter is changed. The report consists of several pages which are implemented as subreports. All the pages work fine unless there's need to change portfolio-parameter.

The report is about financial data and it has parameters: Start date, End date and Portfolio. These are inserted in the portal. When I view a Portfolio, e.g. AAA01, the report works fine. But when I change the portfolio to AAA02 the report crashes. The report works again when I refresh by using F5. But I can't leave it at that, now can I? 

Start, End date and Portfolio are all parameters send to SQL DB with the query. 

The text displayed as error message reads: "Data retrieval failed for the subreport. "Name goes here". locat at: "The name of the report again". Pleace check the log files for more information." The funny part about this is that even this text doesn't render well it's missing its bottom half. Which log might this be referring to? Is it found on PBI admin portal or should I check the DB logs on-prem?

So any ideas? Thanks!

[v-deddai1-msft]

Hi @GoingIncognito ,

It could be a data access error. Please refer to https://docs.microsoft.com/en-us/power-bi/paginated-reports/subreports-troubleshoot

If your data source is on-premise sql db. Please try to update the gateway to the latest version.  and you can also enable additional logging function to troubleshoot the issue. Please refer to  https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance#slow-performin...

Fiddler is a free tool from Telerik that monitors HTTP traffic.  You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

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

Best Regards,

Dedmon Dai