Behind Power BI data load and transformation functionality is the M language. In this session, learn what kind of scenarios you’ll need to use the M language in, as well as its basic syntax. See several practical examples of how to use M in the wild, for example creating and using functions, handling missing or changed data sources, and calling web services.
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.