راهنمای جامع اتوماسیون CI/CD، کنترل نسخه و استقرار مدل‌های داده با Tabular Editor 3 CLI در محیط‌های Air-Gapped

       [توسعه‌دهنده هوش تجاری] ─── Push ───► [Git Repository: Gitlab / Gitea]
                                                        │
                                                        ▼ (Webhook Trigger)
       ┌────────────────────────────────────────────────────────────────────────┐
       │             سیستم رانر خودکار CI/CD (Local GitLab Runner / Jenkins)     │
       │                                                                        │
       │  ۱. دریافت آخرین کامیت مدل پوشه‌بندی شده (Folder Serialized Model)     │
       │  ۲. اجرای TabularEditor3.exe CLI جهت کامپایل و اعتبارسنجی ساختار       │
       │  ۳. اجرای آزمون‌های Best Practice Analyzer (BPA Ruleset)                │
       │  ۴. استقرار اتمیک فراداده‌ها از طریق پورت XMLA به سرور مقصد            │
       │  ۵. اجرای اسکریپت TMSL / PowerShell برای رفرش هوشمند پارتیشن‌های اخیر  │
       └───────────────────────────────────┬────────────────────────────────────┘
                                           │
                         پروتکل امن XMLA / Windows Integrated Auth
                                           │
                                           ▼
       ┌────────────────────────────────────────────────────────────────────────┐
       │             سرورهای عملیاتی دیتاسنتر (Production SSAS / PBIRS)         │
       │ - سرور Power BI Report Server محلی (PBIRS 2022/2024)                   │
       │ - کلاستر فشرده Analysis Services با کشینگ حافظه‌محور VertiPaq          │
       └────────────────────────────────────────────────────────────────────────┘

/bi-semantic-model-repo
│
├── /src/Model
│   ├── database.json
│   ├── model.json
│   ├── /tables
│   │   ├── DimDate.json
│   │   ├── DimCustomer.json
│   │   ├── FactGlTransactions.json
│   │   └── /FactGlTransactions/partitions/Partition_2026.json
│   ├── /relationships
│   │   └── Rel_FactGl_DimDate.json
│   └── /expressions
│       └── SourceSqlServerInstance.json
│
├── /bpa-rules
│   └── enterprise-bpa-rules.json
│
└── /cicd
    ├── deploy-model.ps1
    └── process-partitions.tmsl

<#
.SYNOPSIS
    Automated Validation and BPA Audit using Tabular Editor 3 CLI
    Designed for Isolated / Air-Gapped DevOps Environments
#>
[CmdletBinding()]
param(
    [Parameter(Mandatory = $true)]
    [string]$ModelSourceFolder,

    [Parameter(Mandatory = $true)]
    [string]$BpaRulesPath,

    [Parameter(Mandatory = $false)]
    [string]$Te3CliPath = "C:\Program Files\Tabular Editor 3\TabularEditor3.exe"
)

$ErrorActionPreference = "Stop"

Write-Host "[INFO] Starting Tabular Editor 3 Model Validation..." -ForegroundColor Cyan

if (-not (Test-Path -Path $Te3CliPath)) {
    throw "[FATAL] Tabular Editor 3 CLI executable not found at: $Te3CliPath"
}

# Step 1: Validate Model Metadata Compilation from Folder Structure
$validationLog = "bpa-validation-report.xml"
$processArgs = @(
    "$ModelSourceFolder",
    "-B", "$BpaRulesPath",
    "-V",
    "-W",
    "-O", "$validationLog"
)

Write-Host "[EXEC] Invoking Tabular Editor 3 BPA Analyzer..." -ForegroundColor Yellow
$process = Start-Process -FilePath $Te3CliPath -ArgumentList $processArgs -NoNewWindow -Wait -PassThru

if ($process.ExitCode -ne 0) {
    Write-Host "[ERROR] BPA Validation Failed with Exit Code: $($process.ExitCode)" -ForegroundColor Red
    if (Test-Path $validationLog) {
        Get-Content $validationLog | Select-Object -First 30
    }
    exit $process.ExitCode
}

Write-Host "[SUCCESS] All Best Practice Rules passed cleanly. Model is deployment-ready." -ForegroundColor Green

<#
.SYNOPSIS
    Atomic Deployment of Tabular Model to Production PBIRS/SSAS Instance
#>
param(
    [string]$ModelSourceFolder,
    [string]$TargetServer = "pbirs-node01.licentra.lan",
    [string]$DatabaseName = "Finance_Corporate_Semantic_Model"
)

Write-Host "[DEPLOY] Deploying metadata to $TargetServer ($DatabaseName)..." -ForegroundColor Cyan

$deployArgs = @(
    "$ModelSourceFolder",
    "-D", "$TargetServer",
    "-N", "$DatabaseName",
    "-O", # Overwrite existing metadata
    "-S", # Skip direct table schema processing during metadata sync
    "-V"
)

$deployProc = Start-Process -FilePath "C:\Program Files\Tabular Editor 3\TabularEditor3.exe" `
                            -ArgumentList $deployArgs -NoNewWindow -Wait -PassThru

if ($deployProc.ExitCode -ne 0) {
    throw "[FATAL] Metadata Deployment failed! Status code: $($deployProc.ExitCode)"
}

Write-Host "[DEPLOY-OK] Metadata successfully published to target instance." -ForegroundColor Green

{
  "refresh": {
    "type": "calculate",
    "objects": [
      {
        "database": "Finance_Corporate_Semantic_Model"
      }
    ]
  }
}

{
  "refresh": {
    "type": "add",
    "objects": [
      {
        "database": "Finance_Corporate_Semantic_Model",
        "table": "FactGlTransactions",
        "partition": "Partition_2026_Q1"
      }
    ]
  }
}