After several years using Power Bi Desktop with many users I see that a bad practices are still implemented. At first I thought it was adjusted to the tool being new or inexperienced users. However, I'm thinking the reason is because of the lack of content about Power Query.

What I'm talking about is the bad habit of generating an enormous number of steps in the query editor to clean up data sources. Some time ago I found a short video of an Indian generating tips for the reduction of steps in Power Query which led me to think "I should generate content from this too".

This article will show some daily examples of Power Query to reduce the steps of our queries

Free Tutorial!