PBI-ApplyIncrementalRefreshPolicy.ps1

## 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>"  

## 
$connStr = "Data Source=powerbi://api.powerbi.com/v1.0/myorg/$workspace;User ID=app:$($clientID)@$($tenantID);Password=$clientSecret"

## Load AMO - via loading the SqlServer module
import-module SqlServer

## connect to the XMLA endpoint
$server = new-object Microsoft.AnalysisServices.Tabular.Server
$server.Connect($connStr) 
$db = $server.Databases.FindByName($databaseName)
$table = $db.Model.Tables[$tableName]

"Initial Partition count: $($table.Partitions.Count)"

$table.ApplyRefreshPolicy($false, 1)

"Final Partition count: $($table.Partitions.Count)"

$server.Disconnect()