Chapter 7: Logging Data from Power BI to External Sources
As you've learned from previous chapters, Power BI uses Power Query as a tool for extract, transform, load (ETL) operations. The tool in question 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 is only able to read information from the outside. In fact, the most stringent limitation of Power Query is its inability to write information outside of Power BI. However, thanks to the integration of analytical languages such as Python and R, you'll be able to 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
