PowerShell script to deploy model metadata from *bim files to SQL Server Analysis Services

[Anonymous]

I have a remote server that will be used as Power BI and Analytics Services on premises Everything necessary is installed there (SQL + SSAS +PBIRS + Kerberos) One of my challenges is to deploy model metadata from *.bim files (that are stored in GitLab) to SSAS with the help of PowerShell

I would like to write a PowerShell script that would be executed from GitLab CI pipeline (note that I can only build Linux based containers that can run PowerShell scripts) which would grab specific .bim file and deployed it to SSAS (TabularEditor might be used?!) Any help would be much appreciated!

[Anonymous]

Hi @Anonymous ,

Please refer these documents, hope is helpful for you :

Deploy a SQL Server Analysis Services Project using PowerShell – Vanie's View (vaniecastro.com)

Load Testing SSAS with PowerShell - Microsoft Community Hub

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.