Power BI’s built-in ETL tool, Power Query, is capable of reading data that is stored in a variety of formats into memory, making transformations to the data while in memory, and loading the transformed data into the Power BI data model. It does a great job of doing these types of tasks as it can handle most ETL situations.
However, Power BI falls short if you want to log information about your Power BI data loads. Power Query is designed to read data but not to write data. Fortunately, that is not the case with R and Python. R and Python have packages and libraries, respectively, ...
