Abstract
Power BI has built-in tools that enable you to read Microsoft Excel files into the Power BI data model. The built-in functionality is intuitive and easy to use for simple workflows, but things can become unnecessarily difficult when the workflows get complicated. Many workflows that are difficult to do using native Power BI tools are relatively easy to do using R or Python. We will illustrate with an example.
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 Excel Files. In: Advanced Analytics in Power BI with R and Python. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5829-3_4
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5829-3_4
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)