Deila með


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.

See also

Business Central and Power BI (docs)