Filling cells, say with colour, beyond the range where it is absolutely needed can lead to problems when importing Excel spreadsheets into Power BI. Performance gains can be made by removing formatting.
Recently I came across an excellent blog post from Jethro Seghers that covered getting started with Office 365 PowerShell Automation. In the post Jethro walks through the process of setting up Visual Studio Code to work with Visual Studio Services. The process uses Git as the broker. The end result is that your scripts can be stored in a secure source repository.
In following the post I learned several lessons that I thought I'd share
The moral here is if you change the number of columns in a file you need to update the Source definition in Power BI