Once you have automated the SIMS Report, you might want to automate the need to load up Power BI and press refresh and publish. This video shows you how you can do this by installing a Power BI gateway. Once installed, the whole process of refreshing the csv files in SIMS, refreshing the Power BI report and publishing to the Power BI service is automatic, leaving you plenty of time to get on with designing more Power BI reports!