dgosbell

#r "System.Net.Http"
using System.Net.Http;
using System.Text;
using Newtonsoft.Json.Linq;

// You need to signin to https://platform.openai.com/ and create an API key for your profile then paste that key 
// into the apiKey constant below
const string apiKey = "<YOUR API KEY HERE>";
const string uri = "https://api.openai.com/v1/completions";
const string question = "Explain the following calculation in a few sentences in simple business terms without using DAX function names:\n\n";

dgosbell

// =====================================
// Author: Darren Gosbell
// Date: 12 Apr 2023
// This script works in Tabular Editor and sets the MaxParallelismPerQuery 
// setting at the database level.
// =====================================

if (Model.Database.CompatibilityLevel < 1569)
{
    Model.Database.CompatibilityLevel = 1569;

dgosbell

#r "System.Net.Http"
using System.Net.Http;
using System.Text;
using Newtonsoft.Json.Linq;

// You need to signin to https://platform.openai.com/ and create an API key for your profile then paste that key 
// into the apiKey constant below
const string apiKey = "<YOUR API KEY HERE>";
const string uri = "https://api.openai.com/v1/completions";
const string question = "Explain the following calculation in a few sentences in simple business terms without using DAX function names:\n\n";

dgosbell

#Requires -Modules MicrosoftPowerBIMgmt

<#
.SYNOPSIS
    This script will move all workspace in one capacity to another capacity
.DESCRIPTION
    
.NOTES
    File Name  : Move-PowerBICapacityWorkspaces.ps1
    Author     : Darren Gosbell

dgosbell

#r "System.Net.Http"
using System.Net.Http;
using System.Text;
using Newtonsoft.Json.Linq;

// you need to create a resource and deploy a model in Azure OpenAI 
// to get the following 3 pieces of information
// see https://learn.microsoft.com/en-us/azure/cognitive-services/openai/how-to/create-resource?pivots=web-portal
const string apiKey = "<your API key";
const string resource_name = "<your resource name>";

dgosbell

## NOTE: editing your dataset via the XMLA endpoint will prevent you from downloading it
##       so make sure you have a backup of the original pbix file

$clientID = '<your-clientId>'
$clientSecret = '<your-client-secret>'
$tenantID = '<your-teantId>'

$workspaceName = 'Xmla%20Test'
$datasetName = 'Role Test'
$roleName = 'DynamicRole'

dgosbell

## This script will apply an incremental refresh policy to generate 
## empty partitions for that policy using a Service Principal via the XMLA endpoint

$workspace = "XMLA%20Test"
$databaseName = "Adv Works Inc Refresh Base"
$tableName = "Internet Sales"
$clientID = "<Your SPN Client ID>"
$tenantID = "<Your TenantID>"
$clientSecret = "<Your SPN Secret>"  

dgosbell

#Requires -Version 3.0

param(
[Parameter(Mandatory=$true)]
[string]$serverName, 
[Parameter(Mandatory=$true)]
[string]$databaseName, 
[Parameter(Mandatory=$true)]
[string]$pathToBimFile
)

dgosbell

$process = "MSMDSRV"
get-process -name $process | % {get-nettcpconnection -OwningProcess $_.id} | select-object @{Name="Process"; Expression = {$Process}},LocalPort, RemotePort, OwningProcess
$process = "PBIDesktop"
get-process -name $process | % {get-nettcpconnection -OwningProcess $_.id} | select-object @{Name="Process"; Expression = {$Process}},LocalPort, RemotePort, OwningProcess

dgosbell

### Author: Darren Gosbell (https://darren.gosbell.com)
### Date  : 22 Jan 2021 
### Usage : To use this script just update the following 4 variables for you environment


$server = "localhost\tab17"
$database = "adventure works"
$query = “evaluate 'Date'”
$filename = “c:\temp\tofile.csv”