BI4Dynamics - D365 F&O Architecture with Data Lake

This video shows the Data Lake Architecture of BI4Dynamics's Finance and Operations Solution.

The video is led by BI4Dynamics's Solution Architect, who divides the architecture into 3 subsections:
► Preparation
►Transformation
►Consumption

As he finishes with the elaboration of the Transformation subsection of Data Lake Architecture, our Solution Architect continues by showing the real experience and the benefits BI4Dynamics F&O Solution brings to the end-user. In this segment, he briefly goes through and explains the reports this solution has to offer.

Would you like to experience the reports BI4Dynamics has to offer? - No worries!

Login to Power BI service with the following credentials:

►Password: PBIweL0Ve

Furthermore, he continues with the Consumption subsection and ends the presentation by emphasizing the difference between Power BI Pro vs Power BI Premium and the pricing of Azure.

Link to Power BI Account:

Timestamps:
00:00 Architecture: Subsections
00:48 Architecture: Preparations
02:02 Architecture: Preparations - Export to Data Lake
07:09 Architecture: Transformation
08:12 Architecture: Transformation - Power BI - Content
12:04 Architecture: Transformation - Power BI - Credentials
12:19 Architecture: Transformation - Power BI - Content
18:27 Architecture: Consumption - Implementation Options
20:47 Architecture: Consumption - Convergence
25:48 Architecture: Consumption - Convergence - Paginated Reports
28:11 Architecture: Consumption - Convergence - Power BI Pro vs Premium
30:01 Architecture: Consumption - Convergence - Azure Costs

[goelrommel]

Thanks for deep dive explanation of fetching the data from dynamics 365 till power BI. I have one question >

Scenario :

Step 1: We have exported the required tables to Azure Data Lake Gen 2
Step 2: Created the views within Azure Synapse Analytics
Step 3: Connected synapse and power BI
Step 4: Performed some extra ETL within Power BI
Step 5: Created data model and reports within Power BI Desktop
Step 6: Implemented incremental refresh for each data set within power BI (Archive 1 year, Refresh past 7 days)
Step 7: Published report to power Bi services.
Step 8: Scheduled refresh for 16 times a day.

Question :
1. Does Synapse will only query the data for past 7 days? or it will query for the complete data sets?
2. Which filed we should use for Incremental refresh & Detect data Change in Power BI


Thanks & Kind Regards,
Rommel