Power BI is extremely powerful but there’s more to it than just connecting to your data sources and building the visualizations for your reports. The common scenario is needing to connect to more than one data source to create your reports and needing all of that data to work together. Unless your requirements and data is extremely simple, 99% of the time you will need to shape and transform your data before creating your reports. This session will do a deep dive into the Query Editor in Power BI Desktop and demonstrate common reporting scenarios and how to transform the data to get the desired end result. You will also learn important Query Editor tips and tricks.