
Extending Power BI with Python and R
By :

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: