BRK4003 - Microsoft Power BI: Building connectors
Data in the real world is messy and never available in the exact form that users need for their analysis or reports. Data Analysts need to spend a significant amount of their time working on data preparation, before the data is ready to be visualized and analyzed. Power Query, together with the Mashup Engine, provide a best-in-market experience for importing, reshaping and combining data from a wide range of data sources. This Power Query experience surfaces in a wide range of Microsoft products and workloads including Power BI Desktop, Excel, Analysis Services and Common Data Service for Applications. Furthermore, you can leverage the Power Query SDK to create Custom Connectors that can be easily plugged into Power Query in order to extend its capabilities. In this session, we will teach you everything you need to know in order to start leveraging these capabilities and taking data to the next level.
BRK3003 - Microsoft Power BI: Connect and transform data from hundreds of data sources using Power Query
Business users spend a significant amount of their time working on data preparation before the data is ready to be used. Power Query and M are Microsoft’s data connectivity and data preparation technologies integrated across many different products (Excel, Microsoft Power BI, Common Data Service, Microsoft Flow, etc.). They provide a best-in-market experience for importing, reshaping, and combining data from a wide range of data sources, including File sources, Enterprise-grade sources such as SAP HANA/BW, Azure-based sources, and many others. In this session, learn everything you need to know to succeed at leveraging these capabilities and taking your data to the next level. See several demos of new capabilities coming to Power Query over the next few months.