How To Automatically Remove All Empty Columns In Power Query

In this video, Melissa demonstrates how you can automatically remove all empty columns from a table in Power Query. Melissa’s approach will involve the standard Table.Profile M library function and its additional aggregates parameter to add a non-empty count column. ***** Video Details ***** 00:00 Introduction 00:12 Sample query 01:36 Data set 02:13 Select columns 04:08 Add non-empty count column 09:07 Custom function ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - http://www.enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - https://www.enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - https://www.enterprisedna.co/membership Enterprise DNA Online - http://portal.enterprisedna.co/ Enterprise DNA Events - https://www.enterprisedna.co/enterprise-dna-events-page/ #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial