The Ten Pitfalls of the Data Wrangler (aka the Wielder of M/Power Query)
Ten Pitfalls of the wrangling of using Power Query and how to avoid them, written by P3 Adaptive , Rob Collie.
Ten Pitfalls of the wrangling of using Power Query and how to avoid them, written by P3 Adaptive , Rob Collie.
A description on how to import CSV files into Power BI with their filenames.
The first thing I ever do when I create a new PowerPivot workbook is create the date tables that I need.
If you’re anything like me, you will have eagerly sucked data into PowerPivot, keen to get cracking with solving all of your reporting needs.