Forum Discussion

PImre's avatar
PImre
Frequent Visitor
1 year ago
Solved

Incremental Refresh Initial load in partitions - without SSMS

Hi,   How is it possible to do partitional Initial load of and Incremental Refresh model without SSMS?  I was able to create the partitions in Tabular Editor and updated the Model in the Service v...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    $Server = "powerbi://api.powerbi.com/v1.0/myorg/XXX Opportunity Conversion Reports"
$Database = "Opportunity Field History"
$TableName = "Opportunity Field History"
$RefreshType = "Full"
Invoke-ProcessPartition -PartitionName "2013Q203" -TableName $TableName -Database $Database  -RefreshType $RefreshType -Server $Server
Invoke-ProcessPartition -PartitionName "2013Q204" -TableName $TableName -Database $Database  -RefreshType $RefreshType -Server $Server
Invoke-ProcessPartition -PartitionName "2013Q205" -TableName $TableName -Database $Database  -RefreshType $RefreshType -Server $Server

    This is just one of many different ways to do it.

lbendlin's avatar
lbendlin
Super User
1 year ago

Can you run Powershell scripts?

PImre's avatar
PImre
Frequent Visitor
1 year ago

Yes

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    $Server = "powerbi://api.powerbi.com/v1.0/myorg/XXX Opportunity Conversion Reports"
$Database = "Opportunity Field History"
$TableName = "Opportunity Field History"
$RefreshType = "Full"
Invoke-ProcessPartition -PartitionName "2013Q203" -TableName $TableName -Database $Database  -RefreshType $RefreshType -Server $Server
Invoke-ProcessPartition -PartitionName "2013Q204" -TableName $TableName -Database $Database  -RefreshType $RefreshType -Server $Server
Invoke-ProcessPartition -PartitionName "2013Q205" -TableName $TableName -Database $Database  -RefreshType $RefreshType -Server $Server

    This is just one of many different ways to do it.