(Livestream Replay) Tabular Editor C# Scripts & Calculation Groups - with Bernat Agulló

Join Bernat Agulló and I as he shows you how to level up your skills in Tabular Editor! He'll spend time showing you how to use C# scripts and macros to create calculation groups, diagnose and optimize your model, and much more! Plus learn how to leverage Visual Studio to create and tune the C# scripts.

GUEST BIO 👤

Partner and Senior BI Developer at Esbrina, a BI consulting company based in Barcelona. Passionate about Power BI in general, DAX and Calculation groups in particular. I love automating things, first it was VBA and Excel, now is Tabular Editor c# scripts and Power BI I have spoken in several events and user groups around the world about calculation groups.

RELATED CONTENT 🔗

Bernat’s Twitter
Bernat’s Blog
Bernat’s LinkedIn
Bernat’s YouTube
Bernat’s GitHub
Tabular Editor Site

(Livestream Replay) Power BI & Power Automate: Increase Your Productivity - with Ed Hansberry

In this session Ed Hansberry will walk you through some common use cases in Power BI that can best be handled using its teammate in the Power Platform, Power Automate. By creating some basic flows, you can let end-users refresh reports right from the report, customize scheduled refreshes, automate the sending of emails to clients, customers, vendors, etc. You are only limited by your imagination!

GUEST BIO 👤

Ed Hansberry is a Certified Public Accountant that decided working with data was more interesting than making journal entries. He has experience in supply chain for consumer products goods, which involves forecasting for production and sales. Most of his data analysis career involved using Microsoft Access as a backend for Excel until the early 2010's when tools like Power Query, Power Pivot, and ultimately, Power BI came out. In 2020, he was given the Microsoft MVP award for Data Platform mostly for his work in the Power BI Community forum. Now he works in Power BI and related technologies for a living at P3 Adaptive as a principal consultant.

RELATED CONTENT 🔗

Ed's LinkedIn
Ed's Twitter

PBI-Tools Setup and Configuration to GitHub & Azure DevOps- with Mathias Thierbach

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.

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
PBI Tools - Azure
PBI Tools - GitHub
Mathias Notes/Articles
Mathias's Twitter
Mathias's LinkedIn
Mathias's GitHub

(Livestream Replay) Don't be Afraid of the Advanced Editor - with Erik Svensen

One of the first steps of becoming a M-Code Ninja is to master the few elements in the M Language. When you know the basic elements like lists, records, tables, parameters, and functions, the next steps will be a lot easier. In the session we will go through what these elements are and how and where you can use them in order to become a (M)inja. Through a series of demos Erik will get you comfortable with editing your queries so they can be more dynamic and execute with less lines of code.

GUEST BIO 👤

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 60+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He runs the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his wine shop and his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

Erik's Blog
Erik's LinkedIn
Erik's Twitter