8
Logging Data from Power BI to External Sources
As you’ve learned in previous chapters, Power BI uses Power Query as a tool for extracting, transforming, and loading (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. This includes a graphical query editor for point-and-click transformations, the ability to extract data from multiple sources, comprehensive column and row transformations, data cleaning functions, and the ability to perform simple calculations. The output of these transformations is persisted in the Power BI data model. Power Query is a read-only tool. In fact, its biggest limitation is its inability ...
Get Extending Power BI with Python and R - Second Edition 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.
