Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Mogry
Advocate I
Advocate I

Report Server Reports not useable after n minutes of inactive time

Hi everybody,

 

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.

 

Unbenannt.png

 

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

3 REPLIES 3
d_gosbell
Super User
Super User


@Mogry wrote:

Is this somehow configurable or fixable?


Possibly, you would need to start by clicking on one of the details links in one of the visuals that has failed to get information on why the visual has an error. If there is some sort of timeout the solution will depend on what timing out is being triggered. If you could provide the error message from the link on the visuals that would help us. 

The error messages on the visuals are basically saying that there is no data and I should try it again later. 

Hmm, that does not give us much to go on. You could maybe also try checking the Report Server logs to see if they have any more information. Or you could try running a profiler or XEvent trace against your SQL Server. It could be an issue with SQL Server timing out the idle connections listening for error events. (see https://www.red-gate.com/simple-talk/blogs/identifying-client-timeouts/)

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.