PsXmla

PsXmla connects XMLA and PowerShell. It gives you PowerShell Cmdlets with the power of Microsoft.AnalysisServices.Tabular. For example you can automate your work with Tabular Editor and the Power BI XMLA endpoints.

Installation

This module can be installed from PsGallery.

Install-Module -Name PsXmla -Scope CurrentUser

Alternatively it can be build and installed from source.

1. Install the development dependencies
2. Download or clone it from GitHub
3. Run the installation task:

Invoke-Build Install

Usage

TODO

Commands

Command	Description	Status
Connect-Instance	Create a new database connection.	☑
⮱ Polly Retries	Implement retry policies on Polly	☐
Disconnect-Instance	Close connection	☑
Invoke-Command	Execute SQLCMD scripts	☐
⮱ Retry support	Specify the number of retry attempts	☑
⮱ Power BI exceptions	Parse and handle exceptions from Power BI	☐

Changelog

See the changelog file.

Development

• This is a Portable Module based on PowerShell Standard and .NET Standard.
• VSCode is recommended as IDE. VSCode Tasks are configured.
• Build automation is based on InvokeBuild
• Test automation is based on Pester
• Commands are named based on Approved Verbs for PowerShell Commands

Build

The build scripts require InvokeBuild. If it is not installed, install it with the command Install-Module InvokeBuild -Scope CurrentUser.

You can build the module using the VS Code build task or with the command Invoke-Build Build.

Release

1. Create release branch using gitflow.
2. Update version number in psd1 file.
3. Update changelog in this readme file.
4. Uninstall old versions.
5. publish release using Invoke-Build Publish.
6. finish release using gitflow.