pbi-tools is a command-line tool bringing source-control features to Power BI. It works alongside Power BI Desktop and enables mature enterprise workflows for Power BI projects.

An example project is available here: https://github.com/pbi-tools/adventureworksdw2020-pbix

• Twitter Hashtag: #pbitools

• See https://pbi.tools/cli/

• All build targets are implemented using FAKE.
• Dependencies are managed using Paket.
• Main entry point for all build tasks is .\build.cmd.
• The fake-cli tool is installed as a local .NET Core Tool, see .config\dotnet-tools.json. The build.cmd script handles the tool installation.

• Visual Studio 2022 17.2 or later (for MSBuild dependencies), incl C# 11 Preview
• .Net 4.7.2 Targeting Pack
• .Net 6.0 SDK
• Power BI Desktop x64 (Must be installed in default location for local development: C:\Program Files\Microsoft Power BI Desktop\)

dotnet fake build --list

The project strictly adheres to SemVer v2 for release versioning. The build system uses the first entry in RELEASE_NOTES.md to inject version numbers into build artifacts.

• Log output can be controlled using the environment variable PBITOOLS_LogLevel.
• Allowed values are:
  • Verbose
  • Debug
  • Information
  • Warning
  • Error
  • Fatal
• The default is Information, which is also effective when an unknown/invalid option has been specified.

.\build.cmd Build

.\build.cmd Test

.\build.cmd Pack

.\build.cmd UsageDocs -s
dotnet fake build -s -t SmokeTest

dotnet paket install

That is generally not needed as the build.cmd script takes care of fetching dependencies. However, it could be useful to run this manually on a fresh clone or after making changes in the paket.dependencies file.

dotnet paket update Microsoft.AnalysisServices.retail.amd64
dotnet paket update Microsoft.AnalysisServices.AdomdClient.retail.amd64

dotnet paket update
dotnet paket update -g Fake-Build

dotnet paket outdated -g Main

dotnet fake {...}
dotnet fake -t Build
dotnet fake --version

.\pbi-tools.local.cmd extract '.\data\Samples\Adventure Works DW 2020.pbix'

.\pbi-tools.local.cmd extract '.\data\Samples\Adventure Works DW 2020.pbix' -extractFolder '.\data\Samples\Adventure Works DW 2020 - Raw' -modelSerialization Raw

$env:PBITOOLS_LogLevel = "Debug"

.\build.cmd Publish -s
.\build.cmd Pack -s

git clone --recurse-submodules https://github.com/pbi-tools/pbi-tools.git

git submodule update --remote

git clone -b Release/1.0.0-beta.9 --single-branch --recurse-submodules https://github.com/pbi-tools/pbi-tools.git ./1.0.0-beta.9