Power Platform and Excel: 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 (Microsoft Excel, Power BI, Common Data Service, Power Apps, Power Automate, Dynamics 365 Customer Insights, Azure Data Factory, and more!). 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. We also give you a sneak peek at several demos of new capabilities coming to Power Query over the next few months.