Summary
In this chapter, you got your first detailed look at Power Query. You also learned all about the query settings that you should not ignore when working with Power Query. So, you should now be able to customize the environment to suit your requirements.
You should also now possess the knowledge to complete the required steps to create a basic query and import the queries back to Excel or Power BI using all the Load To… options in detail.
We also discussed data profiling tips and learned how these options can enhance the visual interpretation of data within your query.
In the next chapter, we will learn how to connect to numerous data sources, such as a web page, between Access databases and Excel workbooks, import text and comma-separated value files, and discuss multiple connections. We will end the chapter by investigating the data source settings.