Updating the fact table in Financial reporter can have a massive performance impact on the D365 application as both the FR database and AXDB must reside on the same SQL server.

Using a High-Availability group we can replicate AXDB to a secondary SQL server to act as a read-only D365 database, perfect for reporting purposes.

We recently had a need to refresh the FR database but doing so in office hours resulted in a completely unusable D365 application.

Please can you look into a way of configuring Financial reporter to retrieve its data from a different SQL server.

Thanks.