mthierba

name: Deploy-UAT

# Controls when the workflow will run
on:
  push:
    branches:
      - 'Release/*'

  # Allows you to run this workflow manually from the Actions tab
  workflow_dispatch:

mthierba

{
  "version": "0.12",
  "created": "2022-05-25T15:24:03.2613259+01:00",
  "deployments": {
    "Contoso": {
      "mode": "Dataset",
      "source": {
        "type": "Folder",
        "path": "./Contoso Sales"
      },

mthierba

GET https://api.powerbi.com/v1.0/myorg/groups
Authorization: Bearer {{$aadV2Token scopes:https://analysis.windows.net/powerbi/api/.default clientId:7f67af8a-fedc-4b08-8b4e-37c4d127b6cf}}

mthierba

<Query Kind="Statements">
  <NuGetReference>Microsoft.AnalysisServices.retail.amd64</NuGetReference>
  <Namespace>TOM = Microsoft.AnalysisServices.Tabular</Namespace>
</Query>

var asm = typeof(TOM.Server).Assembly;
var compatAttr = asm.GetType("Microsoft.AnalysisServices.Tabular.CompatibilityRequirementAttribute");

string ReadProperty(string name, object attr) => compatAttr.GetProperty(name).GetValue(attr).ToString();
string GetMemberType(Type t) => t.IsEnum ? "Enum" : t.IsInterface ? "Interface" : "Class";

mthierba

<Query Kind="Statements">
  <NuGetReference>Microsoft.AnalysisServices.retail.amd64</NuGetReference>
  <Namespace>AMO = Microsoft.AnalysisServices</Namespace>
  <Namespace>TOM = Microsoft.AnalysisServices.Tabular</Namespace>
</Query>

var dbName = "AdventureWorksDW2014";

var model = new TOM.Model {
	DefaultPowerBIDataSourceVersion = TOM.PowerBIDataSourceVersion.PowerBI_V3,

mthierba

1. git init
2. Paket-Init (cinst -y Paket.PowerShell)
3. Copy paket.bootstrapper.exe (from https://github.com/fsprojects/Paket/releases/latest) to ./.paket/paket.exe
4. Create paket.dependencies
5. Create build.cmd, build.fsx
6. Create .gitignore
7. Run Paket-Install
8. Run ./build.cmd

mthierba

<Query Kind="Statements">
  <NuGetReference>Microsoft.AnalysisServices.retail.amd64</NuGetReference>
  <Namespace>TOM = Microsoft.AnalysisServices.Tabular</Namespace>
</Query>

var table = new TOM.Table();
table.Measures.Add(new TOM.Measure 
{ 
	Name = "Measure1", 
	Expression = @"

mthierba

$release = Invoke-RestMethod -Uri "https://api.github.com/repos/Seddryck/NBi/releases/latest"
Write-Output "Latest release found: $($release.name)"
$url = $release.assets[0].browser_download_url

# Possible improvements:
#  params for outdir/tempdir/release
#  use GetTempPath() to download .zip file to (or use current folder)
	
pushd $PSScriptRoot

mthierba

Add-PSSnapin "Microsoft.SharePoint.PowerShell"

$issuerID = "11111111-1111-1111-1111-111111111111"

$targetSiteUrl = "http://wingtipserver"
$targetSite = Get-SPSite $targetSiteUrl
$realm = Get-SPAuthenticationRealm -ServiceContext $targetSite

$registeredIssuerName = $issuerID + '@' + $realm

mthierba

$makecert = "C:\Program Files\Microsoft Office Servers\15.0\Tools\makecert.exe"
$certmgr = "C:\Program Files\Microsoft Office Servers\15.0\Tools\certmgr.exe"

# specify domain name for SSL certificate
$domain = "appserver.wingtip.com"

# create output directory to create SSL certificate file
$outputDirectory = "c:\Certs\"
New-Item $outputDirectory -ItemType Directory -Force -Confirm:$false | Out-Null