Havens Consulting
A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This episode will focus on how to check for blanks, nulls, and zeros your measures!
Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.
SQLBI Return 0 Instead of Blank
Daniil's Blog
Daniil's Twitter
Daniil's LinkedIn
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 second 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 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.
In 2015, after having spent over ten years as a Software Developer and Architect with Microsoft technologies, Mathias Thierbach moved into the Microsoft BI space. He soon landed on Power BI, but also realized quickly that the development and engineering tools and practices were nothing like the ones well established in software development. This is how pbi-tools started as a project, filling this gap in tooling. Today, leading a growing data management team at YouGov, he experiences the benefits of those efforts every day. Having open sourced the project in fall of 2021, Mathias spends a lot of his free time bringing those practices to the wider Power BI community now.
PBI Tools
PBI Tools - Azure
PBI Tools - GitHub
Mathias Notes/Articles
Mathias's Twitter
Mathias's LinkedIn
Mathias's GitHub
A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This episode will focus on optimizing TRUE/FALSE conditions and data types!
Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.
When you're learning a new technology or upskilling in a specific tool, chances are that you'll need to connect with your peers that are trying to achieve the same, or already went through this path. In this live stream, we will talk about one of the most vibrant technical communities, the Power BI community, and how joining it may help you not just to master specific concepts, but also give you a career boost and new opportunities.
I'm making music from the data! PowerBI consultant and trainer, Microsoft Data Platform MVP, Pluralsight Author, blogger, speaker...Interested in everything related to data - always eager to extract valuable info from raw data in the most effective way. Multi-year experience working with (predominantly) Microsoft Data Platform (SQL Server, SSAS, SSIS, SSRS, and Power BI). Father of 2 and true football (and Barca) fan!
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
