Deploy BIM file to Power BI premium workspace

Hello,

I'm trying to deploy a bim file in my repo through TE to PowerBI, i've followed your doc and tested differents ways to setup the connection but i still have a problem deploying my BIM file as a new dataset to PowerBI, my action below

`name: DeployBIM on: workflow_dispatch: jobs: build: runs-on: windows-latest environment: MyEnvironment name: DeployBim steps:

uses: actions/checkout@v3 with: fetch-depth: 0
name: Download TBE run: | $TabularEditorUrl = 'https://cdn.tabulareditor.com/files/te2/TabularEditor.Portable.zip' $DownloadDestination = Join-Path (Get-Location) "TabularEditor.zip" Invoke-WebRequest -Uri $TabularEditorUrl -OutFile $DownloadDestination Expand-Archive -Path $DownloadDestination -DestinationPath (Get-Location).Path Remove-Item $DownloadDestination

name: Deploy to Power BI run: | $ErrorActionPreference = "Stop" $InformationPreference = "Continue" $root_path = (Get-Location).Path Write-Information "Working Directory: $root_path"

    Set-PSRepository PSGallery -InstallationPolicy Trusted
    Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser
    Import-Module -Name MicrosoftPowerBIMgmt

    Write-Information "Using Service Principal authentication!"
      $tenant_id = "****"
      $client_id = "***"
      $client_secret = "***"
      $login_info = "User ID=app:$client_id@$tenant_id;Password=$client_secret"

      [securestring]$sec_client_secret = ConvertTo-SecureString $client_secret -AsPlainText -Force
      [pscredential]$credential = New-Object System.Management.Automation.PSCredential ($client_id, $sec_client_secret)

      Connect-PowerBIServiceAccount -Credential $credential -ServicePrincipal -TenantId $tenant_id

      $executable = Join-Path $root_path TabularEditor.exe
      $bimFileName = "demoReport.database.json"
      $bimPath = Join-Path $root_path $bimFileName

      Test-Path -Path $bimPath -PathType Leaf

      $ASDatabaseName = "testName"

      $connection_string = "powerbi://api.powerbi.com/v1.0/myorg/Embedded;initial catalog=$($ASDatabaseName)"

      $params = @(
        """Provider=MSOLAP;Data Source=$connection_string;$login_info"""
        """$($ASDatabaseName)"""
      )
      $ServerInstance = "Provider=MSOLAP;Data Source=$connection_string;$login_info"
      $params2 = @("$bimPath", "-D", "$ServerInstance", "$ASDatabaseName", "-O", "-V")

        Write-Information "$indention $executable $params"
        Write-Information "$indention $executable $params2"

        $p = Start-Process -FilePath $executable -Wait -NoNewWindow -PassThru -ArgumentList $params2

        if ($p.ExitCode -ne 0) {
          Write-Error "Failed to deploy .bim file from!!!!!"
        }`

The error below says that the server is not running

Question: do i need to specify the name of the new dataset like in the $connection_string var ? NB: the dataset does not exist yet i want to create a new one from my BIM file, is that possible?

Thank's in advance for your help

TabularEditor / TabularEditor

Deploy BIM file to Power BI premium workspace #994