Power-Bi-Devops-Alm-Best-Practices

// Power BI project file organization
├── Model/
│   ├── model.tmdl
│   ├── tables/
│   │   ├── FactSales.tmdl
│   │   └── DimProduct.tmdl
│   ├── relationships/
│   │   └── relationships.tmdl
│   └── measures/
│       └── measures.tmdl
├── Report/
│   ├── report.json
│   ├── pages/
│   │   ├── ReportSection1/
│   │   │   ├── page.json
│   │   │   └── visuals/
│   │   └── pages.json
│   └── bookmarks/
└── .git/

# Initialize Power BI project with Git
git init
git add .
git commit -m "Initial Power BI project structure"

# Create feature branch for development
git checkout -b feature/new-dashboard
git add Model/tables/NewTable.tmdl
git commit -m "Add new dimension table"

# Merge and deploy workflow
git checkout main
git merge feature/new-dashboard
git tag -a v1.2.0 -m "Release version 1.2.0"

# Automated deployment using Power BI REST API
$url = "pipelines/{0}/Deploy" -f "Insert your pipeline ID here"
$body = @{ 
    sourceStageOrder = 0 # Development (0), Test (1)
    datasets = @(
        @{sourceId = "Insert your dataset ID here" }
    )      
    reports = @(
        @{sourceId = "Insert your report ID here" }
    )            
    dashboards = @(
        @{sourceId = "Insert your dashboard ID here" }
    )

    options = @{
        # Allows creating new item if needed on the Test stage workspace
        allowCreateArtifact = $TRUE

        # Allows overwriting existing item if needed on the Test stage workspace
        allowOverwriteArtifact = $TRUE
    }
} | ConvertTo-Json

$deployResult = Invoke-PowerBIRestMethod -Url $url -Method Post -Body $body | ConvertFrom-Json

# Poll deployment status
$url = "pipelines/{0}/Operations/{1}" -f "Insert your pipeline ID here",$deployResult.id
$operation = Invoke-PowerBIRestMethod -Url $url -Method Get | ConvertFrom-Json    
while($operation.Status -eq "NotStarted" -or $operation.Status -eq "Executing")
{
    # Sleep for 5 seconds
    Start-Sleep -s 5
    $operation = Invoke-PowerBIRestMethod -Url $url -Method Get | ConvertFrom-Json
}

# Azure DevOps pipeline for Power BI deployment
trigger:
- main

pool:
  vmImage: windows-latest

steps:
- task: CopyFiles@2
  inputs:
    Contents: '**'
    TargetFolder: '$(Build.ArtifactStagingDirectory)'
    CleanTargetFolder: true
    ignoreMakeDirErrors: true
  displayName: 'Copy files from Repo'

- task: PowerPlatformToolInstaller@2
  inputs:
    DefaultVersion: true

- task: PowerPlatformExportData@2
  inputs:
    authenticationType: 'PowerPlatformSPN'
    PowerPlatformSPN: 'PowerBIServiceConnection'
    Environment: '$(BuildTools.EnvironmentUrl)'
    SchemaFile: '$(Build.ArtifactStagingDirectory)\source\schema.xml'
    DataFile: 'data.zip'
  displayName: 'Export Power BI metadata'

- task: PowerShell@2  
  inputs:
    targetType: 'inline'
    script: |
      # Deploy Power BI project using FabricPS-PBIP
      $workspaceName = "$(WorkspaceName)"
      $pbipSemanticModelPath = "$(Build.ArtifactStagingDirectory)\$(ProjectName).SemanticModel"
      $pbipReportPath = "$(Build.ArtifactStagingDirectory)\$(ProjectName).Report"
      
      # Download and install FabricPS-PBIP module
      New-Item -ItemType Directory -Path ".\modules" -ErrorAction SilentlyContinue | Out-Null
      @("https://raw.githubusercontent.com/microsoft/Analysis-Services/master/pbidevmode/fabricps-pbip/FabricPS-PBIP.psm1",
        "https://raw.githubusercontent.com/microso