rarely used reports that are no longer working

Question

I have 2 questions and want to ask some suggestion?

If rarely used SSRS reports are no longer working now? What are possible reasons?
If rarely used power BI reports are no longer working now? What are possible reasons?

Thank you very much for your help.

David

Answer 1

Hi @Davidoj ,

Power BI is the superset of SSRS, so the possible reasons for not working is really similar

Couldn't fully understand your meaning of reports that are not working.

Do you mean that when you run a report it couldn't render by long time?

Or when you run the report, it will show the error message such as rsAccessDenied,rsInternalError.

There are many reasons for reports not working.

For the first scenario, please check the excution log3 for detail messages to see which spent it cost long time for.

For the second scenario, you may do further analysis based on error messages.

Here are some official documentations for your reference.

https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15

https://learn.microsoft.com/en-us/sql/reporting-services/troubleshooting/cause-and-resolution-of-reporting-services-errors?view=sql-server-ver15

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October