Power Pivot to SSAS Tabular: Automatically Publish Excel Workbooks

In Part I we explored how powerful one of the Server Options can be for Excel Power Pivot. Be it SharePoint, SSAS Tabular or Power BI - moving up to the server option lets you separate the Model from the Reports and unleash the potential of Power Pivot. For Part II, we will continue exploring the SSAS Tabular option. Specifically once you choose to host your Model on SSAS Tabular, you are faced with two options