Skip to content
A single lightweight powershell module with cmdlets to manage SSAS Instances (On-Prem or Azure)
PowerShell
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.vscode
Modules/SSASHelper
.gitignore
AzureAS.AutoScheduler.ps1
LICENSE
README.md
SSASHelper.CreatePartitionsSample.ps1
SSASHelper.ProcessObjectsSample.ps1
SSASHelper.SetAzureASStateSample.ps1

README.md

ssas-powershell-modules

A single lightweight powershell module with cmdlets to manage SSAS Instances (On-Prem or Azure) Complete samples provided with the modules!

##Install Module from PowerShell Gallery

# In a Admin PowerShell console
Install-Module SSASHelper

Invoke-SSASCommand ...

##(Re)Create Partitions

Invoke-SSASCreatePartition `
    -connectionString $connStr `
    -database "AW Internet Sales Tabular Model" `
    -table "Internet Sales" -partition "Internet Sales 2014" `
    -datasource "Adventure Works DB from SQL" `
    -query $query `
    -verbose

##Process Partition

Invoke-SSASProcessCommand -connectionString $connStr -database "AW Internet Sales Tabular Model" -table "Internet Sales" -partition "Internet Sales 2014" -Verbose

##Process Table

Invoke-SSASProcessCommand -connectionString $connStr -database "AW Internet Sales Tabular Model" -table "Internet Sales" -Verbose

##Process Database

Invoke-SSASProcessCommand -connectionString $connStr -database "AW Internet Sales Tabular Model" -Verbose

##Suspend/Resume Azure AS

Set-AzureASState `
    -resourceGroupName "YourResourceGroup" `
    -serverName "YourServerName" `
	-ApplicationID "YourApplicationId" `
	-ApplicationKey "YourApplicationKey" `
	-tennantid "YourTennantId" `
	-SubscriptionId "YourSubsciptionId" `
	-action "suspend"

Full tutorial on https://devscopebi.wordpress.com/2016/12/14/automate-azure-analysis-services-pauseresume-using-powershell/

Authors

License

This project is licensed under the MIT License - see the LICENSE.md file for details

Acknowledgments

You can’t perform that action at this time.