Share via

Azure Analysis Service Tabular Model - TMSL Merge Partition script error

Naveen Kumar 1 Reputation point
2022-09-15T17:06:20.407+00:00

I am trying to merge existing table partition in Azure Analysis Service to main table using below TMSL script. 

{     
  'mergePartitions': {     
    'target': {     
      'database': 'AASDatabase',     
      'table': 'sales',     
      'partition': 'Partition'     
    },     
    'sources': [     
      {     
        'database': 'AASDatabase',     
        'table': 'sales',     
        'partition': 'sales_20220901'     
      }    
    ]     
  }     
}

Below is the error I am facing

241470-image.png

I have only one partition 'sales_20220901' which I want to merge back to main table to make it as a whole table

Could someone help me to understand the issue?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 38,401 Reputation points Microsoft Employee
    2022-09-19T09:49:54.03+00:00

    Hi @Naveen Kumar ,

    Thank you for posting query in Microsoft Q&A Platform.

    From the error, it seems permissions related issue for the identity which runs the script. Kindly Click here to know more about roles and permissions needed and try to implement same and see if that helps.

    Please let me know how it goes. Thank you.