© Ryan Wade 2020
R. WadeAdvanced Analytics in Power BI with R and Pythonhttps://doi.org/10.1007/978-1-4842-5829-3_5

5. Reading SQL Server Data

Ryan Wade1 
Indianapolis, IN, USA

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

Get Advanced Analytics in Power BI with R and Python: Ingesting, Transforming, Visualizing now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.