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.
For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.