New season and new article on technical architecture for reporting / BI and analysis with Dynamics 365 Finance and Operations. Here, I will introduce a new ability to push data from tables and entities into Azure Data Lake storage in real time, as well as how to use it with Azure Synapse Analytics and PowerBI afterwards. How to create a modern Datawarehouse architecture for your ERP and expose views and a custom model for your end users in PowerBI. How to use DirectQuery mode with SqlOnDemand mode (pay per request – without server) + Azure Analysis Services: in order to have an end-to-end real-time flow for reporting from your ERP data!
Demo here in 4K :
See you soon !