You are a solution architect for a company that uses Dynamics 365 finance and operations apps. The company does not have a centralized reporting strategy. You create a solution design document. The…

Question

Options

• AAzure Data Lake database
• BMicrosoft Dataverse
• CTransactional database
• DEntity store database
• EBring your own database (BYOD)

• A
  6% (2)
• B
  3% (1)
• C
  11% (4)
• D
  77% (27)
• E
  3% (1)

Explanation

The Entity Store is an operational data warehouse built into Dynamics 365 Finance and Operations, specifically designed as the data source for Power BI embedded reports and dashboards. It contains pre-aggregated analytical data models (measurements) that are optimized for reporting, and the out-of-the-box Power BI content packs for D365 are built on top of it. The transactional database (C) should never be used for reporting as it impacts application performance. Azure Data Lake (A) and BYOD (E) are advanced export scenarios requiring additional setup. Microsoft Dataverse (B) is the platform database for Power Platform / CE apps, not the primary analytical source for Finance and Operations data.

No community discussion yet for this question.