Azure Data Factory Analysis Services API call for adding new partition to tabular model

nik.chalkanov 1 Reputation point
2022-08-26T06:16:38.907+00:00

Is it possible to add new partition with API call to the Analysis service logical server . Someting like:

createOrReplace:{
....

"partition": {
"name": "Sales2019",
"mode": "import",
"source": {
"type": "m",
"expression": [
"let",
" Source = #\"SQL/sqlserver database windows net;Contoso\",",
" dbo_Sales = Source{[Schema=\"dbo\",Item=\"Sales\"]}[Data],",
" #\"Filtered Rows\" = Table.SelectRows(dbo_Sales, each [OrderDateKey] >= 20190101 and [OrderDateKey] <= 20191231)",
"in",
" #\"Filtered Rows\""
]
},

}

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,640 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. MartinJaffer-MSFT 26,036 Reputation points
    2022-08-26T22:32:01.01+00:00

    Hello @nik.chalkanov ,
    Thanks for the question and using MS Q&A platform.

    The ask is whether there is a (REST?) API for adding partitions to Azure Analysis Services Tablular model.

    There is no REST API call to do this under Azure Analysis Services, but there are some related Powershell commands that might. The AAS powershell blends partly with the SQL powershell.
    Specifally invoke-ascmd

    Excerpt:

    Database operations
    Azure Analysis Services database operations use the same SqlServer module as SQL Server Analysis Services. However, not all cmdlets are supported for Azure Analysis Services.
    The SqlServer module provides task-specific database management cmdlets as well as the general-purpose Invoke-ASCmd cmdlet that accepts a Tabular Model Scripting Language (TMSL) query or script.

    There is a chance that under one of the SQL categories there is a REST api, but identifying which one, and whether it is supported, is a much more difficult task.

    Please do let me if you have any queries.

    Thanks
    Martin

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments