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.
Here is the scenario:
It is February 2, 2014, and you are the CFO of Contoso International.
You receive sales data by year via MS Excel workbooks from your IT department, ...
