Power BI is the leading platform for business intelligence. The core of the Power BI platform is formed by datasets with DAX calculation capabilities that enable interactive reporting on large sets of data. Join this session to learn about another way to use this technology: perform hugely complex aggregations and calculations to enrich business processes.
In this session, we present a Power BI solution based on a real-life use case involving BC and the Power Platform. We deal with inventory analysis and financial settlements for perishable goods, like tomatoes, for which the age of inventory is relevant. The Power BI model requires recursive calculations over a period of one week, which is the base unit for the client’s business process. The calculation results are fed back to BC using Power Automate and Power Apps. The same set-up is used to run scenario analyses over extended periods of time. We discuss the solution architecture and do a deep dive on the specifics of the calculation engine implemented in Power BI.