| title | description | author | ms.service | ms.topic | ms.date | ms.author | ms.reviewer |
|---|---|---|---|---|---|---|---|
Manage Azure Analysis Services with PowerShell | Microsoft Docs |
Describes Azure Analysis Services PowerShell cmdlets for common administrative tasks such as creating servers, suspending operations, or changing service level. |
kfollis |
analysis-services |
conceptual |
04/27/2021 |
kfollis |
minewiskan |
This article describes PowerShell cmdlets used to perform Azure Analysis Services server and database management tasks.
Server resource management tasks like creating or deleting a server, suspending or resuming server operations, or changing the service level (tier) use Azure Analysis Services cmdlets. Other tasks for managing databases like adding or removing role members, processing, or partitioning use cmdlets included in the same SqlServer module as SQL Server Analysis Services.
[!INCLUDE updated-for-az]
Most PowerShell tasks require you have Admin privileges on the Analysis Services server you are managing. Scheduled PowerShell tasks are unattended operations. The account or service principal running the scheduler must have Admin privileges on the Analysis Services server.
For server operations using Azure PowerShell cmdlets, your account or the account running scheduler must also belong to the Owner role for the resource in Azure role-based access control (Azure RBAC).
Install module - Az.AnalysisServices
Documentation - Az.AnalysisServices reference
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. The following cmdlets in the SqlServer module are supported for Azure Analysis Services.
Install module - SqlServer
Documentation - SqlServer reference
| Cmdlet | Description |
|---|---|
| Add-RoleMember | Add a member to a database role. |
| Backup-ASDatabase | Backup an Analysis Services database. |
| Remove-RoleMember | Remove a member from a database role. |
| Invoke-ASCmd | Execute a TMSL script. |
| Invoke-ProcessASDatabase | Process a database. |
| Invoke-ProcessPartition | Process a partition. |
| Invoke-ProcessTable | Process a table. |
| Merge-Partition | Merge a partition. |
| Restore-ASDatabase | Restore an Analysis Services database. |