Hi there,
To be honest there is no one answer here because there are too many variables depending on the environment you are working on.
If your BC environment is online (SaaS), you can make use of the Performance Profiler as suggested and let Microsoft have a look, alternatively if that report was customized incorrectly, it can also lead to performance issues, especially if performed well in the past, get the developer that made the change to investigate and find an alternative method for the change that does not impact performance.
If your environment is self-hosted (meaning the BC runs on an internal server at your company), there other factors that can affect performance:
- customizations made to the running report causing performance degradation
- customizations made to surrounding objects (tables and keys) of the records being used in the running report
- poor performance of the hardware the Business Central server is running on which affect the report you are running as data cannot be fetched quick enough, this is an internal IT issue and need to be reported to them.
There can be other factors but these are 9 out of 10 times the culprits.
Hope this helps.
