Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

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

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!

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.