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 ...

Get Extending Power BI with Python and R now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.