Posts From Category: VSTS

Build Tabular Models through hosted agent

Working with a modern BI setup it is important to ensure that continious deployment (build and release) is handled automatically using tools like Azure Devops or other similar tools.

On most projects i have been working we have utilized a self-hosted agent for these activites and therefore had a lot of control of what is installed once and then reused by the agent. This appraoch have been working great for a lot of situations. This have by quite some time been my preferred way of doing things when using Tabular Editor, mainly because the AMO libraries have not been available for download in any easy acessible way.

Recently i have been playing around with some scenarios to avoid installing the agent on hosted environments since a full-blown BI setup in azure does not really need any hosted machines. Due to this i have been investigating if i could get away with only using the hosted agent.

I have decided to download the latest version of the AMO library even with SSDT already installed on the host. This is simply because the hosted agent only have version 14.0.0.0 of the TOM AMO libraries installed. The currently latest version of AMO library is 15.7.0.2.

# Load security protocol to handle HTTPS connection to GitHub
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

# Load Github release details for Tabular Editor
$TabularEditor = Invoke-WebRequest -Uri "http://api.github.com/repos/otykier/TabularEditor/releases/latest" | ConvertFrom-Json;

# Identify download path from for TabularEditor.zip for download purposes
$TabularEditorDownloadPath = $TabularEditor.Assets | Where-Object { $_.name -eq "TabularEditor.zip" }  | Select-Object @{N="DownloadPath";E={$_.browser_download_url }} 

# Download file to root of repository
$TabularEditorZip = join-path (get-location) "TabularEditor.zip"
Invoke-WebRequest -Uri $TabularEditorDownloadPath.DownloadPath -OutFile $TabularEditorZip

#Unzip and delete archive
Expand-Archive -Path $TabularEditorZip -DestinationPath  (get-location).Path
Remove-Item $TabularEditorZip

# Install AMO package to Tabular Editor to run
# Make sure we have Nuget.exe
$nugetFolder = Join-Path $env:LOCALAPPDATA "Nuget"

$nugetExe = Join-Path $nugetFolder "Nuget.exe"

if (-not (Test-Path $nugetFolder)) {
    New-Item $nugetFolder -ItemType Directory
}

if (-not (Test-Path $nugetExe)) {
    $ProgressPreference = "SilentlyContinue"
    Invoke-WebRequest 'https://dist.nuget.org/win-x86-commandline/latest/nuget.exe' -OutFile $nugetExe
}

& $nugetExe update -self

# Download AMO Libraries
$nugetExe = [System.IO.Path]::Combine($Env:LOCALAPPDATA, "Nuget", "Nuget.exe")
& $nugetExe install Microsoft.AnalysisServices.retail.amd64 -OutputDirectory (get-location) -ExcludeVersion

# Move AMO DLL's to Tabular Editor for it to run
$AMOFilePath = Join-Path (get-location) "Microsoft.AnalysisServices.retail.amd64\lib\net45"
Move-Item -Path "$AMOFilePath\*" -Destination (get-location)

Read More