Join our book community on Discord
https://packt.link/EarlyAccessCommunity
As you've learned in previous chapters, Power BI uses Power Query as a tool for extract, transform, and load (ETL) operations. This tool is really very powerful – it allows you to extract data from a wide variety of data sources and then easily transform it with very user-friendly options in order to persist it into the Power BI data model. It is a tool that can only read information from the outside. In fact, Power Query’s biggest limitation is its inability to write information outside of Power BI. However, by integrating analytical languages such as Python and R, you can persist information about Power Query loading and transformation processes to external files or systems. In this chapter, you will learn the following topics:
- Logging to CSV files
- Logging to Excel files
- Logging to (Azure) SQL Server
