we mainly have reports which are connected via direct query to SQL Server 2014 databases. Report Server September 2019 is in use.
My customer often opens a report, configure it, leave it like this for n minutes (mostly over 10 or 15 minutes) and is returning to it later to reuse it. The issue with PBIRS and this behaviour of my customer is, that the reports are having a timeout so they are not usable until the page is refreshed or the report is opened again.
My guess is, that this has something to do with the direct query mode and the connection in the backgorund to the sql server. Is this somehow configurable or fixable? Or is this something the customer has to take because it is a natural behaviour in this situation?
Cheers and thanks in advance