Power BI isn’t just a read-only historical view of your data - you can also enter parameters which feed into your model and drive outputs under different scenarios. In this session Rishi will show this process using a simple Power Apps form embedded into Power BI, supported by a basic workflow. This solution is made even more seamless by combining a Direct Query connection to the parameter table with an imported data model on the full dataset, utilising the new Composite Model feature of Power BI. Also learn how to utilise this feature to build aggregate tables – fast in-memory tables for viewing data grouped by one or more dimensions with an automatic switch to Direct Query when drilling down into transaction-level views. The sheer breadth of uses cases to which this can apply, and the performance/power it can bring to your reports is guaranteed to take your breath away!