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 via ALM Toolkit but I am stuck at this point.

I have no admin rights on my PC but I am admin of the Premium capacity workspace I am using. 

 

Thanks. 

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.

6 Replies

      • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PImre,

    Thank you for reaching out in Microsoft Community Forum.

    Thank you lbendlin  for the helpful response.

    As suggested by Ibendlin,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

    Please continue using Microsoft community forum.

    Regards,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PImre,

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

    Thank you,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PImre,

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

    Thank you,
    Pavan.