Forum Discussion

kshen's avatar
kshen
Regular Visitor
3 years ago

Report Not Responding Upon Opening

Hi all,

 

I am currently experiencing a isssue that the report was not responding after it was loading the data upon opening. I used the direct query mode. I have checked the sql server database it connected to and all queries were running with no problem. I also checked the other reports using the same database with direct query mode and also they appeared working well. Is there any other method potentially helping me out?

 

Thanks

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Check the query duration for each of the visuals on your reprt page. If you can identify the culprit check the query and look for excessive number of records in the query plan.  Refactor the participating measure(s)