Microsoft Dynamics 365 Financial and Operation and Power BI

There are 4 ways of finding insights from Microsoft Dynamics 365 Finance and operation. The easiest way is running entity store which is customized by Microsoft to use inside power queries. the PROS of this way is the easy installation and using inside the Power BI data flows. However the CONS of this way is that you may not have access of all filed of different modules.

the Second way is to use the secondary SQL database to store all necessary data and entities from Dynamics 365 finance and operation. here we may find more data and staging tables. However, this way is tie consuming, decreasing the D365 performance. in this way the batch job controller should define many batch jobs to export data to the SQL database which is time consuming and also again you may not have access to all fields and sometimes the Data analyst need to ask for creating the custom entities.

The Export to Data Lake feature lets you copy data from your finance and operations apps into your own data lake (Azure Data Lake Storage Gen2). The system lets you select the tables and entities that are included. After you select the data that you want, the system makes an initial copy. The system then keeps the selected data up to date by applying changes, deletions, and additions. After data changes in your finance and operations app instances, there might be a delay of a few minutes before the data is available in your data lake.

Microsoft Azure Synapse Link for Dataverse lets you choose data from finance and operations apps. Use Azure Synapse Link to continuously export data from finance and operations apps into Azure Synapse Analytics and Azure Data Lake Storage Gen2.
Azure Synapse Link for Dataverse is a service that's designed for enterprise big data analytics. It provides scalable high availability together with disaster recovery capabilities. Data is stored in the Common Data Model format, which provides semantic consistency across apps and deployments.