Automate MSBI deployments Using PowerShell


Microsoft BI tools are widely used in Business Intelligence (BI) projects nowadays due to their end to end BI capabilities and lower licensing costs. We work in an agile world where the application teams are making use of various tools, like Jenkins, to speed up and automate their deployments, whereas we see that BI teams still follow a more traditional approach for deploying BI artifacts. We can get out of this rut by leveraging the excellent compatibility between the MSBI deployment utilities and PowerShell.

The traditional MSBI stack comprises the following tools:

SSIS: an ETL tool for moving data between