Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Ryan Wade
About this chapter
Cite this chapter
Wade, R. (2020). Reading SQL Server Data. In: Advanced Analytics in Power BI with R and Python. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5829-3_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5829-3_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5828-6
Online ISBN: 978-1-4842-5829-3
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)