Power Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13

Download Zipped Folder with All Files: https://excelisfun.net/files/13-M365ExcelClassVideoFiles.zip This video is a comprehensive lesson in Power Query Importing & Transformation Data in Excel & Power BI. This video shows extensive M Code to create formulas to convert bad data into proper data sets that can be used for analysis. This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW This video covers. 1. (00:00) Introduction and video topics 2. (02:24) On-Premise Folder and File Path 3. (03:11) Importing TXT and CSV files 4. (08:08) Create Dynamic File Path in Excel 5. (15:13) Import CSV File with Extra Rows at Top 6. (16:34) Import PDF File 7. (18:22) Import from a Picture 8. (19:30) Import XML File 9. (20:48) Import JSON File 10. (22:24) Import Web Site 11. (25:43) Import Excel File. 12. (26:31) Excel.Workbook function 13. (28:14) Dataflows (Online Power Query) to Import & Transform 14. (35:20) Import Dataflow Tables (Dynamic Data Source) 15. (37:16) Connect to Power BI Data (Single Source of Truth) 16. (39:31) Import Dataverse Data 17. (39:52) Import SQL data & Query Folding 18. (44:51) From Folder for TXT files (Automatic Feature) 19. (49:53) From Folder for 1 Sheet Excel files (Automatic Feature) 20. (51:43) Create Dynamic Folder Path 21. (52:33) Folder.Contents & Folder.Files functions 22. (53:20) From Folder for CSV files (Custom Formula) 23. (56:55) Power BI Parameter for Folder Path 24. (58:33) From Folder for Multiple Object Excel files(Custom Formulas) 25. (01:04:29) Consolidate Excel Tables in Current File using Excel.CurrentWorkbook 26. (01:09:27) Universal Dynamic Folder Path 27. (01:11:44) Fix Inconsistent Field Names in Append (Custom Formulas). Code created in Excel. 28. (01:13:41) Csv.Documnet (Secret Tricks) 29. (01:24:06) Fix Inconsistent Field Names in Power BI Desktop (Custom Formula) 30. (01:25:05) Remove Blank Rows & Columns, Fix Field Names and Add Dynamic Data Types with Custom Column let statement (replaces Custom Function) 31. (01:48:26) Video Summary and Conclusions 32. (01:49:11) Closing and Video Links Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/ #excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #powerbi #powerquery #powerbidesktop #mcode #mcoder #importdata #transformation #freeclass #freecourse #freeclasses #excelclasses #powerbicourse #powerquery #powerquerytutorial #microsoftexcel #microsoftmvp #datamodel #datamodeling