Leading Zeros Disappear or Text Becomes Garbled When Importing CSVs into Power Query | How to Fix Data Types and Character Encoding During Import

The shortest procedure to fix garbled text and missing leading zeros in CSVs with Power QueryAre you tired of the leading zeros in your customer codes disappearing the moment you import them, forcing ...
Chris Webb's BI Blog

Improvements To Power Query Integration In Power BI Report Builder

There are some nice improvements to Power Query integration in the latest version of Power BI Report Builder that, while they are documented, didn’t get an official blog post but which I think deserve ...

Preparation before consolidating multiple CSVs in Power Query: Why you should align column names and folders

When you want to consolidate monthly CSVs into a single table, your first instinct is to look for Power Query operations. However, if the shapes of the original files are inconsistent, problems such ...