Curated list of publicly available materials about pbi-tools, including User Group and Conference presentations

Upcoming Events

Conference Sessions Delivered

PASS Data Community Summit, Seattle (November 2022)

Power BI Model Development Best Practices in a Team

Power BI projects often start very small, with a single person quickly creating impressive results using Power BI Desktop and a project that is fully contained in a single file. When those early successes are then expected to scale in an enterprise context and to be replicated by a larger team, things get more complicated. There is no obvious scale-out path, particularly with regard to model development. Mathias, who has been on this exact journey over the past five years, presents the practices he has developed during that time, going from a single contributor beginning to a highly effective team setup. The session covers processes, tools, roles and automation, with a focus on very practical take-aways.

Data Platform Virtual Summit (September 2022)

The internals of a PBIX file and how pbi-tools helps make sense of it all

The PBIX file is the fundamental building block when it comes to Power BI development. You may have heard that PBIX files are simply ZIP files with an internal file structure, however, very little is publicly known beyond that.

Mathias, for his work on pbi-tools, has spent years deciphering the (undocumented) PBIX internals. Those efforts have led to pbi-tools, today the only end-to-end source control solution for Power BI development.

This session will explain what’s inside a PBIX file and how everything is linked together. Using the folder structure view of a PBIX file provided by pbi-tools, all of the components (Model, Report, Queries, Resources, Settings) will be looked at in detail. You will understand how to track changes made to a PBIX file using Power BI Desktop, what those changes mean, and how to apply similar changes offline, targeting the pbi-tools folder structure only.

Using that understanding, the session will further look into more advanced automation scenarios which become viable once the PBIX internals are known and provide various examples. This session is likely to inspire you to take your Power BI projects to new levels of automation!

Power BI Next Step, Billund/DK (September 2022)

Incremental Refresh and Partition Management

Co-presented with Mike Carlo

You have lots of data, well Power BI can handle it. Build efficient loading data models by using Incremental Refresh in Power BI.

While setting up incremental refresh is easy, what is happening in Power BI.com is more of a mystery. This session does a deep dive into what happens when you are incrementally refreshing datasets.

This will be a technical dive in to Power BI Incremental refresh using SSMS, SQL Profiler, and Tabular Editor 3

Attendees will walk away with a complete understanding of the Incremental refresh set up within Power BI. Then a technical understanding of what happens at the Analysis services side inside PowerBI.com.

Extra topics also covered:

  • Hybrid refresh policies
  • Advanced features enabled via the Tabular Object Model
  • Impact for deployment of datasets (DevOps concerns)

Data Insight Summit, Chicago (September 2022)

Lessons learned building a Power BI Team

You have spent most of your career with a focus on technology and you’re feeling at home in that domain. Now you have been asked to build a team underneath you to take your previous accomplishments to the next level. Or you are considering a career move and step into management. If that is you and you are a technologist who is now a new or aspiring manager, this session will give you plenty of practical advise what to expect and prepare for.

From his own experience of having gone down this path over more than five years, Mathias will present his learnings and insights. It turns out the field of managing people and ensuring a team can function well as a coherent unit is rather different from the field of technology and computers! This session will help you not to feel lost and overwhelmed and instead take on this new challenge with great confidence and joy. The main focus is on “soft skills”, however, embedded in a professional Power BI context.

Most importantly, you will be able to learn from someone else’s mistakes instead of repeating them all yourself! Or, you might instead decide that a move into management is not for you after all and you should rather stay in a single contributor role. Either way, you will walk away with lots of trips & tricks. You will learn techniques for having greater awareness of yourself and others. You will get a useful reading list. And you will get plenty of food for thought and reflection. Ideally, this will make some contribution to making you a better leader and manager!

What is GIT and how do I get started? An introduction for Power BI developers

The session will explain GIT concepts to people who are new to source control or who want to refresh their knowledge. Power BI developers without an engineering background have traditionally felt a little lost in the world of GitHub and Azure Repos. However, tools like Tabular Editor and pbi-tools have brought source control capabilities into the Power BI ecosystem. There are even hints that Microsoft might be taking source control for Power BI more seriously now! Time for everyone to learn the basics, understand the key concepts and know which tools to use and where to find help! If you want to understand what source control is and what terms like git, commit, branch, and pull request mean, this is the session for you. In addition to explaining the basics the session will also demonstrate some end-to-end development workflows using git for Power BI projects.

User Group/Meetup Presentations

17-Oct-2022 Configuring Incremental Refresh with pbi-tools (Live Stream with Reid Havens)

You’ve heard about Power BI Incremental Refresh for datasets but you’re missing powerful tooling? pbi-tools is here to help! Learn how pbi-tools supports you manage, configure, monitor and optimize incremental refresh for your largest datasets. Ask questions and see demos how to automate deploying and refreshing incremental refresh datasets. You’ll hear about refresh policies, auto-managed partitions, effective date and many more technical details.

Introduces new features in pbi-tools 1.0.0-rc.2+preview.5 Release.

Announcement Twitter LinkedIn
Recording https://videos.pbi.tools/2022-10-17-incr-refresh-reidh
Slides https://slides.pbi.tools/2022-10-17-incr-refresh-reidh

20-Jul-2022 Seattle MEUG (Dataset Lifecycle Management)

Power BI Dataset Lifecycle Management with pbi-tools

pbi-tools, the open-source CI/CD and source control tool for Power BI, has had many new features added over the last few months that support enterprise-grade lifecycle management of Power BI (Premium) datasets. The session introduces and demonstrates the latest set of capabilities and puts those in context.

The session covers:

  • PBIX source control with pbi-tools
  • Automated deployments of Power BI datasets through CI/CD pipelines
  • A git branching model for team collaboration with the corresponding CI/CD triggers
  • Flexible and selective dataset refreshes as part of pbi-tools deployments
  • Configuring different deployment environments
  • Deploying SQL Database artifcats alongside Power BI datasets
Event https://www.meetup.com/seattle-modern-excel-users-group-meug/events/282861778/
Abstract https://gist.github.com/mthierba/e9ef6d41f8cc79d50be26adb78df4ae9
Slides https://slides.pbi.tools/2022-07-20-Seattle-MEUG

7-Jul-2022 PBI User Group Switzerland (pbi-tools Intro)

Introducing pbi-tools

pbi-tools is a free and open-source external tool for Power BI, focusing on source control and DevOps capabilities. Learn all about the tool, what it does, and how to get started in this session.

The session covers:

  • PBIX source control with pbi-tools
  • pbi-tools for change tracking in reports and datasets
  • Deployments and DevOps pipelines with pbi-tools
  • All demos and files used during the session are available in a public GitHub repository.
Announcement LinkedIn
Event https://www.meetup.com/power-bi-user-group-switzerland/events/287011457/
Abstract https://gist.github.com/mthierba/ae26b977ceaffe443ec15fcdc39f8e72
Slides https://slides.pbi.tools/2022-07-07-pbitools-intro

21-Jun-2022 Denmark PBI User Group (Branching Model)

Advanced git Branching Model for Power BI

This session introduces in theory and practice a git branching model supporting collaborative incremental releases for Power BI datasets and reports.

The model is collaborative: it is designed for multiple team members working jointly on a shared set of changes.

It is designed for incremental releases: Those continuously deliver business value with a regular and reliable release cadence and allow the product manager, the develop team as well as stakeholders to refer to a particular feature set using a shared versioning scheme.

Using both the source control as well as deployment capabilities of pbi-tools, this model was developed by Mathias as part of building and growing a distributed data management team and was continuously improved over multiple iterations.

Join the session to learn how it works, the thinking behind, and how to adopt it for your own workflows. Foundational understanding of source control and CI/CD is recommended.

Event https://www.meetup.com/denmark-powerbi-user-group/events/286424609/
Abstract https://sessionize.com/s/mathias-thierbach/advanced-git-branching-model-for-power-bi/51805
Recording https://videos.pbi.tools/2022-06-21-Denmark-UG
Slides https://slides.pbi.tools/2022-06-21-Denmark-UG
Materials https://pbi.tools/devops/release-branching-model/

7-Jun-2022 Sri Lankan Power BI Community (Datasets CI/CD)

Power BI Dataset CI/CD with pbi-tools

pbi-tools, the open-source CI/CD and source control tool for Power BI, introduces deployment and refresh capabilities for Power BI (Premium) datasets. The session introduces and demonstrates the new capabilities and explains what you need to set up your own deployment pipelines.

The session covers:

  • PBIX source control with pbi-tools
  • The pbi-tools deployment manifest
  • Creating a GitHub Actions workflow using the pbi-tools Docker image
  • A git branching model for team collaboration with the corresponding CI/CD triggers

All demos and files used during the session are available in a public GitHub repository.

Abstract https://gist.github.com/mthierba/fe82d923704428391fa839e34a15fcc6
Recording https://videos.pbi.tools/2022-06-07-Sri-Lanka-UG
Slides https://slides.pbi.tools/2022-06-07-SriLa-Datasets-CICD

26-May-2022 PBIMCR (Pro Model Dev)

Model Development with pbi-tools

The session introduces and demonstrates Power BI model development workflows and practices in conjunction with pbi-tools and other external tools, like Tabular Editor. pbi-tools (https://pbi.tools/), a free and open-source external tool for Power BI, was developed over the last six years specifically to facilitate mature development practices for Power BI projects. Learn what that means specifically for Power BI models.

Some previously unreleased pbi-tools features are likely to be shown as well.

The session covers:

  • PBIX source control with pbi-tools
  • GIT branching models for team collaboration
  • Automated deployment pipelines with different environments
  • Release-focussed approach for development, testing, deployment
Event https://www.meetup.com/PBIMCR/events/vsvtrsydchbjc/
Abstract https://gist.github.com/mthierba/a9781d4732bf117404fc92ce1641a259
Recording https://videos.pbi.tools/2022-05-26-PBIMCR-Model-Dev
Slides https://slides.pbi.tools/2022-05-26-PBIMCR-Model-Dev
GitHub https://github.com/pbi-tools/dataset-devops-demo

10-May-2022 St Louis UG (REST API)

Deep Dive into the Power BI REST API

The Power BI REST API is the back-end interface for applications and scripts automating Power BI tasks or administrating Power BI Embedded. Particularly in an enterprise context, where automation matters a lot, that API is vital for managing a Power BI infrastructure.

Join this session to learn all the basics about the API, which key use cases there are, what is needed to get started, and which tools are the most helpful. Whether you are a developer, a tenant administrator, or merely interested in all things Power BI, you will likely learn something new and will be able to get some inspiration around automation capabilities.

The session covers:

  • Introducing the REST API (What is it and what can it do?)
  • Selected use cases
  • Authentication (Interactive and Service Principal)
  • Tools (vscode, Postman, PowerShell)
Event https://www.meetup.com/st-louis-sql-server-bi-user-group/events/285699942
Abstract https://gist.github.com/mthierba/6d24f887bfafb14963ff3f7f75da3454
Recording https://videos.pbi.tools/2022-05-10-StLouisUG-REST-API
Slides https://slides.pbi.tools/2022-05-10-StLouisUG-REST-API
GitHub https://github.com/mthierba/pbi-rest-api-vscode-samples

01-May-2022 Delhi (Pro Report Dev)

Developing Power BI Reports with pbi-tools

Announcement LinkedIn
Recording https://videos.pbi.tools/2022-05-01-Delhi-Reports-Dev
Slides https://goto.pbi.tools/pptx-2022-05-01-delhi-ug
GitHub https://goto.pbi.tools/files-2022-05-01-delhi-ug

13-Apr-2022 Stuttgart (Git Intro)

What is GIT and How do I get started?

The session will explain GIT concepts to people who are new to source control or who want to refresh their knowledge. Power BI developers without an engineering background have traditionally felt a little lost in the world of GitHub and Azure Repos. However, tools like Tabular Editor and pbi-tools have brought source control capabilities into the Power BI ecosystem. There are even hints that Microsoft might be taking source control for Power BI more seriously now! Time for everyone to learn the basics, understand the key concepts and know which tools to use and where to find help!

Event https://www.meetup.com/StuttgartPowerPlatformUG/events/284948040/
Recording https://videos.pbi.tools/2022-04-13-PPUG-Stuttgart
GitHub https://github.com/mthierba/git-introduction

24-Mar-2022 Berlin User Group

pbi-tools and Power BI DevOps Pipelines

Mathias Thierbach introduces pbi-tools, an open-source project maintained by him and the ONLY end-to-end source control solution available for Power BI. Mathias will explain the basics of pbi-tools and demo how the tools is used for automated deployments via GitHub Actions and Azure DevOps.

Event https://www.meetup.com/berlin-power-bi-user-group/events/284529940/
Recording https://videos.pbi.tools/2022-03-24-Berlin-Reports-CICD
Slides https://goto.pbi.tools/pptx-2022-03-24-berlin-ug
GitHub https://github.com/pbi-tools/demo-berlin-pug-lfs
https://github.com/pbi-tools/demo-berlin-pug-pbixproj

18-Mar-2022 Des Moines User Group

pbi-tools: Source Control & DevOps for Power BI

Ever since Microsoft launched Power BI back in 2015, report developers and data modelers have been begging for compatibility between Power BI Desktop and enterprise-grade version control solutions like Azure DevOps and GitHub. Now, just a little over 6 years later, a true solution to this problem is finally available, and the best part is… It’s FREE!

pbi-tools by Mathias Thierbach is a powerful new application designed to make it possible to develop, publish, and maintain Power BI projects in a CI/CD pipeline that can automatically analyze new commits for bugs and anti-patterns, detect conflicts between branches, and deploy approved releases to production. PBI Tools is truly a game-changer for Power BI professionals, and we’re very excited to show you how it works, so you can start using it to level-up Power BI development at your own organization.

Event https://www.meetup.com/iowapowerbi/events/283680703/
Recording https://videos.pbi.tools/2022-03-18-Des-Moines-UG
Slides https://goto.pbi.tools/pptx-2022-03-18-des-moines-ug

28-Jan-2022 Deploying Reports with pbi-tools (Live Stream with Reid Havens)

Announcement Twitter LinkedIn
Recording https://videos.pbi.tools/2022-01-28-ReidHavens-Live
Slides https://goto.pbi.tools/pptx-2022-01-28-reid-havens

26-Jan-2022 PUG London

DevOps for Power BI Reports

Are you tired of committing .pbix binary files into your source control system? Does this cause you compliance issues, repo bloat and change tracking nightmares? Why can’t industry-standard DevOps practices be used to manage change control and automated report deployment in Power BI?

The talk briefly looks into the current state of DevOps solutions for Power BI. It will then showcase three different ways of using pbi-tools to implement automated deployment solutions:

  • From .pbix files in your source control system (and how repo bloat can be avoided in that case)
  • From .pbix files, however, additionally using the pbi-tools source control features for change tracking
  • Fully relying on the pbi-tools source control format for deployments

The demos will use Azure DevOps. The techniques and tools used, however, can be adapted to any modern CI/CD system. The focus is on “thin” reports - PBIX projects with a live connection to a remote dataset. All sample projects are provided for free on GitHub.

Event https://www.meetup.com/london-pug/events/283419731/
Recording https://videos.pbi.tools/2022-01-26-London-PUG
Slides https://goto.pbi.tools/pptx-2022-01-26-london-ug

Video Tutorials

Removing the Filter Pane Visibility Toggle for Bookmarks (28 Jun 2022, Havens Consulting)

Taking advantage of the enhanced support for Power BI bookmarks introduced in pbi-tools 1.0.0-rc.2, the session demonstrates how to use pbi-tools to fix a major UX problem bookmarks have today: With the Data option enabled, the expand/collapse state of the report Filters pane is always persisted with the bookmark. Using pbi-tools, and direct access to the report sources, this issue can be resolved.

RECORDING

Calling the Power BI REST API with VS Code (3 May 2022, Havens Consulting)

This talk introduces Visual Studio Code as a simple and convenient tool to access the Power BI REST APIs. Using the free “REST Client” extension, all aspects of the API can be used from within Visual Studio Code: Invocations can be saved for reuse, variables are supported, and API responses are available in full.

You will also learn about the different authentication types (service principal, interactive, admin), how those differ, and how they’re configured.

All examples used in the recording and further notes are available here: https://github.com/mthierba/pbi-rest-api-vscode-samples

Note that this approach is also substantially faster then the “Try It” button integrated into Microsoft’s official API docs here: https://learn.microsoft.com/rest/api/power-bi/

RECORDING

CI/CD Deployment Pipelines for Power BI Reports with pbi-tools (5 Apr 2022, Havens Consulting)

This tutorial describes the setup of a simple automated deployment pipeline for Power BI reports using pbi-tools. It assumes that reports have a live connection to a Power BI dataset and that the PBIX files containing the reports are held in a git repository in either Azure DevOps or GitHub.

The first part of the tutorial explains the setup necessary in the Power BI tenant. Since a service principal is going to be used for the deployment, the necessary steps to get this set up are covered.

Furthermore, the configuration of the pbi-tools deployment manifest is explained, and the deployment is tested locally.

With the basic setup completed, and the deployed tested locally, this part of the tutorial moves the setup into a GitHub repository. A GitHub Actions workflow is created, secrets are set, and the pipeline is tested end-to-end.

The repository created in the tutorial is publicly available here: https://github.com/pbi-tools/tutorial-devops-reports

The final part of the tutorial repeates the steps from Part 2, but this time in Azure DevOps. There are a few additonal settings required here, which the video explains.

The repository created in the tutorial is publicly available here: https://dev.azure.com/pbi-tools/Samples/_git/tutorial-devops-reports

Video Series: “Tool Talk”

Recurring video live stream during which Artur and Mathias discuss pbi-tools related topic, demo new features, and record tutorials. Find all previous recordings here: https://videos.pbi.tools/tool-talk.

UPCOMING: Tool Talk 10: 13-Dec-2022

Tool Talk 9: 8-Nov-2022

Unfortunately, due to a buggy Windows 11 update, my machine’s CPU was maxed out during the recording resulting in a poor video quality.

Tool Talk 8: 4-Oct-2022

Tool Talk 7: 6-Sep-2022

Tool Talk 6: 26-Jul-2022

Tool Talk 5: 5-Jul-2022

Tool Talk 4: 28-Jun-2022

Tool Talk 3: 29-Mar-2022

Tool Talk 2: 15-Mar-2022

Tool Talk 1: 03-Mar-2022

Public Repositories

pbi-tools Demos and Tutorials

Repository Features Created Dataset Notes
contoso-sql-dataset-devops Dataset Deployment, SqlScripts 20-Jul-2022 Contoso Azure SQL Source
dataset-devops-demo Dataset Deployment, Refresh, Deploy-Embedded-Report 26-May-2022 Introducing Calculation Groups PBIMCR Session
contoso-sales-model Dataset Compile 24-May-2022 Introducing Calculation Groups HTTP data source (GitHub)
demo-pug-delhi-20220501 Report: Extract, Watch, Compile 1-May-2022 Introducing Calculation Groups Session: “Developing PBI Reports with pbi-tools”
advworks-git-demo GitHub Issues, Branches 13-Apr-2022 Adventure Works DW 2020 Session: “Introduction to GIT”
report-devops-demo Report Deployment (PbixProj) 24-Mar-2022 Introducing Calculation Groups  
demo-berlin-pug-pbixproj   24-Mar-2022    
demo-berlin-pug-lfs   24-Mar-2022    
devops-github-reports-pbixproj   18-Mar-2022    
devops-demo-report   15-Nov-2021    
adventureworksdw2020-pbix Dataset Compile 16-Apr-2021 Adventure Works DW 2020 HTTP data source (GitHub)

Other

Podcasts

5 Sep 2022 SSBI Podcast (Lars Schreiber)

Link https://ssbi-blog.de/podcast/chat-with-mathias-thierbach/

Own Articles

3rd-party Articles and Mentions

Data Goblins Blog (Kurt Buhler)

Misc

LinkedIn Mentions

Date Author Link
9 Jan 2023 John Kerski Bringing DataOps to Power BI, Part 25: Report Testing
20 Sep 2022 Steve Campbell There are lots of resources available to learn #PowerBI.
5 Sep 2022 Artur König pbi-tools go beyond Power BI with deployment of SQL scripts!
28 Jun 2022 Jens Vestergaard Last week I hosted Mathias Thierbach for a session on Advanced Git Branching Model for Power BI and the recording is now available on the YouTube channel.
26 May 2022 Power BI Manchester UG - #PBIMCR #PBIMCR May session is underway at Robert Walters Manchester office with Mathias Thierbach’s Model Development in PBI-tools Masterclass
7 May 2022 Joel Sherman Also excited about the great work Mathias Thierbach is doing with PBI-tools, to create some #devops order to the BI chaos. His website is here, do check it out!
4 May 2022 Marcus Wegener Do you know this message? “This file can’t be downloaded yet. You can’t download this file right now because it’s been modified using an XMLA endpoint.” How to copy the #PowerBI data model back to a PBIX file anyway, I describe in this blog post.
4 May 2022 Kumar Ranjan Amazing. What a session , i just saw the recording of this powerful session. Prior to this I've never experienced development workflows for Power BI Reports with PBI-tools and also the availability as an open source PBI-tools is the only full source control solution for Power BI.
1 May 2022 Delhi Power BI User Group We had an amazing session today at Delhi Power BI User Group by Mathias Thierbach!! If you missed here's the full recording!!
1 May 2022 Abhinav Singh Do you know about this json that has full pbix metadata? We are live now with Mathias Thierbach speaking on Pbi-tools! Do tune in for learning about an amazing open source - source control solution for Power BI from the author himself!
30 Apr 2022 Mathieu Duftelle I'm already using since several days on Azure Devops the fabulous PBi-Tools : https://pbi.tools/
19 Apr 2022 Colby Timm Wrote a blog article on a really cool Power BI command line tool (pbi-tools) that allows for source/version control.
13 Apr 2022 endjin Power BI Weekly
05 Apr 2022 Reid Havens New Tuesday VIDEOS! In these tutorial videos Mathias Thierbach describes the setup of a simple automated deployment pipeline for Power BI reports using PBI Tools.
28 Mar 2022 Christoph Spieles Hi #PowerBI enthusiasts, recording of last week's #Meetup by Mathias Thierbach on pbi-tools is now available on the MS #PowerPlatform DE #YouTube channel.
21 Mar 2022 Artur König I asked Mathias Thierbach about the Business Case of his pbi-tools - primarily, the tools solved his teams' problem and then he published the tools to others to make Power BI development more professional.
24 Mar 2022 Artur König Mathias Thierbach with his pbi-tools who was at todays Berlin Power BI Usergroup Meetup to show the integration of Azure DevOps and Power BI with the help of pbi-tools.
19 Mar 2022 James V. pbi-tools does for report PBIX files what Tabular Editor does for tabular model BIM files: breaks it out into component .json sections and organizes them in a folder structure to make tracking changes between PBIX saves possible.
3 Mar 2022 Artur König The creator of the awesome PBI-Tools Mathias Thierbach and me will make another talk serien specially about news around the PBI-Tools and the related tech stuff - and we will start today at the evening at 8 PM CEST.
7 Feb 2022 Artur König How to customize the URL in your Power BI Reports? With the pbi-tools by Mathias Thierbach some things are possible that are not possible in the GUI of Power BI
3 Feb 2022 Artur König Power BI Frontend "as code" - habt ihr eure Power BI Berichte schon einmal auf diese Weise betrachtet? Gestern im BI Thinkers Talk hat Marcus Wegener das mit den pbi-tools von Mathias Thierbach gemacht.
1 Feb 2022 Scott Stauffer This is SO Relevant at this time... Working on a with a team on Azure DevOps and PBI and used pbi-tools by Mathias Thierbach.
23 Jan 2022 Reid Havens Join Mathias Thierbach and I this Friday Jan 28th 9AM (PST) as he showcases the PBI-Tools which lets you use established engineering practices such as: change control, branches, and CI/CD pipelines, and deployment for Power BI datasets!