Summary

In this chapter, we introduced different aspects of the Power Query M formula language and looked at how we can use Power Query Editor. We also looked at some real-world scenarios and challenges that can directly affect our productivity and learned how to manage our data preparation step more efficiently.

In the next chapter, we will discuss getting data from various data sources and several connection modes, and how they can affect our data modeling.