Use secondary read-only database for Power BI reporting
Important
This content is archived and is not being updated. For the latest documentation, go to What's new and planned for Dynamics 365 Business Central. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users by admins, makers, or analysts | 
Jan 4, 2022 |
Mar 30, 2022 |
Business value
Performance of the whole system is crucial, even when complex business reports created in Power BI are being refreshed. This feature allows Business Central to perform better because the Power BI reports are being refreshed from a read-only replica.
Feature details
Power BI reports can be now sourced from a secondary, read-only database. This leaves the main database ready for transactions, which enhances performance of the system. This feature is part of the Power BI connector for Business Central. It's enabled by default for all new reports but turned off for existing reports.
This feature complements the read-only support in OData feature delivered earlier in the release. It's available for Business Central online only.