SQLBits 2015

Building A Reporting Solution Using Power Query

See how to use Power Query to build a detail-level reporting solution
Power Query is a desktop ETL tool, right? Well, yes - but it's a lot more than that. In fact you can use Power Query to build an impressive Excel-based reporting solution without going near Power Pivot, and in some cases this approach can be better than using Power Pivot. In this session you'll learn how to:
  • Connect to multiple data sources and combine data from them in Power Query
  • Create parameterised queries in Power Query, and pass parameters to them from your Excel worksheet
  • Build a Reporting Services-like user interface for your reports in Excel
  • Ensure that your reports work in Excel Services as well as on the desktop
  • Make sure that you get the best possible performance in Power Query using query folding
  • Learn when to load data to the Excel Data Model/Power Pivot, and when not to