You're reading from Extending Dynamics 365 Finance and Operations Apps with Power Platform Integrate Power Platform solutions to maximize the efficiency of your Finance & Operations projects

Product type Paperback

Published in Jan 2024

Publisher Packt

ISBN-13 9781801811590

Length 274 pages

Edition 1st Edition

Tools

Dynamics 365

Concepts

Enterprise Resource Planning

Author (1):

Adrià Ariste Santacreu

View More author details

Table of Contents (18) Chapters

Preface

1. Part 1: Dynamics 365 Finance and Operations and Power Platform FREE CHAPTER

2. Chapter 1: Dynamics 365 F&O and Low-Code Development

3. Chapter 2: Dual-Write and Virtual Tables

4. Part 2: Extending Dynamics 365 F&O with Power Platform

5. Chapter 3: Power Automate Flows in Dynamics 365

6. Chapter 4: Replacing F&O Processes with Power Automate

7. Chapter 5: Building Automations and Integrations

8. Chapter 6: Power Apps: What’s in it for Finance and Operations Consultants?

9. Chapter 7: Extending F&O Apps with Power Apps

10. Chapter 8: Power BI Reporting for Dynamics 365 F&O Apps

11. Part 3: Adding AI to Your Flows and Apps

12. Chapter 9: Integrating AI Builder

13. Part 4: Dataverse and Power Platform ALM

14. Chapter 10: Environment Management

15. Chapter 11: Solution Management

16. Index

Why subscribe?

17. Other Books You May Enjoy

The Entity Store and embedded Power BI

We will start this chapter by talking about the Entity Store and seeing why it’s useful but also limited if we want to create new reports.

The Entity Store is a built-in data store in Dynamics 365 F&O. If you’ve ever opened SQL Server Management Studio (SSMS) in a development VM, you’ll have probably seen a database called AxDW; this is where Entity Store data resides.

And what is using this data? If you’re familiar with F&O workspaces, you have probably seen some dashboards being displayed there. These dashboards are Power BI reports that are displayed inside F&O and that consume the data in the Entity Store (see Figure 8.1):

Figure 8.1 – Vendor payments workspace

For example, in the Vendor payments workspace, we see the Analytics tab. This tab contains a Power BI report that’s loading data from the Entity Store. These are known as analytical workspaces...