(Livestream Replay) Lessons learned After Two Years With a Large Model - with Alex Dupler

ABSTRACT 📄

For the past two years, my team has been working on a premium Power BI model that has grown significantly in size, from 50 GB to over 100 GB. During this time, we have gained valuable insights and lessons that we would like to share with you. These include the importance of conducting systematic testing, determining which features and columns will have the most impact on performance, and managing the ongoing refresh of a model of this size. We hope that these tips will be helpful for those looking to optimize and improve their Power BI models.

GUEST BIO 👤

Alex Dupler is a Power BI developer and architect at Microsoft, where he currently serves as the lead Program Manager for a data warehouse platform supporting the company's advertising business. In this role, Alex is responsible for a Power BI import dataset with 90 GB of data. He is also one half of "Two Alex's," a YouTube channel that features live discussions on Power BI topics without one correct answer. Prior to joining Microsoft, Alex worked as a chemist. He is a member of the PBICAT team and has been inactive for a while.

RELATED CONTENT 🔗

Alex's LinkedIn

(Livestream Replay) Don't Panic! I'm Power BI Admin - with Kathrin Borchert

ABSTRACT 📄

The session will focus on the topic of administration in Power BI. Sounds boring? No! Because when you decide on a tool, no matter which one, it is important to set it up and look after it properly.

GUEST BIO 👤

🦄 Kathrin Borchert
💬 Nothing is impossible if you only believe in it
💗 Passion for Data, #PowerBI, UI/UX, ReportDesign, REST API, Governance and Teaching
🌟Logo creator for PowerBIDays, Power Break, PPHHUG

RELATED CONTENT 🔗

🐤 (Twitter)
🕸️ (Website)
📽️ (YouTube)
📣 (Sessionize)
⚡ (PBI User Group Hamburg)
📄 (Other Useful PBI Links)

(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

(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