Introducing the Measure Killer (External Tool) for Power BI!

Learn about an up and coming external tool that makes it easy to identify and KILL unused measures and columns from a Power BI dataset (PBIX). Gregor Brunner will walk us through how to use this great tool, how it works, and more. Tune in to find out!

GUEST BIO 👤

Gregor Brunner is 34 years old, has a background in Economics but moved into Business Intelligence in 2016. Originally from Austria, he moved to Switzerland in 2020 and started Brunner BI, a boutique IT company that specializes in Microsoft Power BI development and consulting.

RELATED CONTENT 🔗

Measure Killer (Site)
Measure Killer (Microsoft Store)
Website

Posted on October 25, 2022 by Reid Havens and filed under Beginner, DAX, Data Modeling, External Tools, Experts and tagged External Tools Data Modeling Best Practices Performance & Optimization.

(Livestream Replay) PowerShell Hacks for Power BI - with James Bartlett

ABSTRACT 📝

There's never a dull moment in the life of a Power BI Administrator. In order to protect our time and sanity, it's important to automate as many of our usual tasks and processes as possible. Additionally, since the top priority of the Power BI development team is the end user experience, there are many edge cases and "power user" type activities that cannot yet be accomplished using only Power BI Desktop and the Power BI web service.

Fortunately, Microsoft has provided two priceless tools that allow us to automate and add functionality to Power BI: The Power BI REST APIs and the MicrosoftPowerBIMgmt module for PowerShell. This presentation will demonstrate several techniques for harnessing these powerful tools to make your job as a Power BI Administrator less time-consuming and more fun!

GUEST BIO 👤

James D. Bartlett III is a Senior Business Intelligence Analyst and Power BI Administrator at Des Moines University in Iowa, USA. He started working in IT way back in 2002, while he was a student in the Business Administration program at Colorado State University. After graduation, James dabbled in banking, real estate, healthcare, and even had a short stint as a resident DJ at Denver's top nightclub, before finally stumbling upon his true calling in the Business Intelligence field in 2018. James is a blogger and co-developer of the Business Ops app on PowerBI.tips, co-leader of the Iowa Power BI User Group, and recently completed his Microsoft Power BI Data Analyst Associate certification. In his spare time, James enjoys longboarding, playing the guitar, and producing electronic music in his home studio.

RELATED CONTENT 🔗

Power BI REST APIs
PowerShell Module
James’ Blog
James’ LinkedIn
James’ Twitter
James’ GitHub

Posted on October 21, 2022 by Reid Havens and filed under Livestreams, Topics & Discussion, Power BI Service, Power Platform, Admin & Management and tagged Sharing / Distribution Apps Workspace Workspace App.

Two Ways to Create Single Value Input Slicers in Power BI!

Learn about two techniques for creating a single value input Slicer in Power BI Desktop!

The first method will apply a technique outlined in a SQLBI article (link below) that uses Tabular Editor to allow native columns (fields) to be modified to allow single value slicer types to be used with them. One consideration is that this technique is not officially supported by Microsoft.

The second method shows you an officially supported method for adding a single value input slicer. This alternative way implements a WhatIf parameter and leverages some clever DAX and relationships to achieve the same result.

RELATED CONTENT 🔗

SQLBI Single Value Slicer
HTML Content Viewer (Daniel Marsh-Patrick)

Video by: Reid Havens

Download Report From The Blog Files Page
Posted on October 18, 2022 by Reid Havens and filed under Slicers & Filters, Data Modeling, DAX, Bookmarks, Intermediate, Beginner, External Tools and tagged Slicers WhatIf Parameters Beginner DAX Tabular Editor.

(Livestream Replay) Configuring Incremental Refresh PBI-Tools - with Mathias Thierbach

ABSTRACT 📝

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.

GUEST BIO 👤

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.

RELATED CONTENT 🔗

PBI Tools
Mathias Notes/Articles
Mathias's Twitter
Mathias's LinkedIn
Mathias's GitHub

Posted on October 17, 2022 by Reid Havens and filed under Livestreams, External Tools, Data Modeling, Power BI Service and tagged PBI-Tools External Tools Incremental Refresh.