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.
This module can be installed from PsGallery.
Install-Module -Name PsXmla -Scope CurrentUserAlternatively it can be build and installed from source.
- Install the development dependencies
- Download or clone it from GitHub
- Run the installation task:
Invoke-Build InstallTODO
| 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 | ☐ |
See the changelog file.
- 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
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.
- Create release branch using gitflow.
- Update version number in psd1 file.
- Update changelog in this readme file.
- Uninstall old versions.
- publish release using
Invoke-Build Publish. - finish release using gitflow.