(Livestream Replay) Building Multi-language Reports for Power BI - with Ted Pattinson

DESCRIPTION 📄

Power BI has a history which has made it challenging to build reports that support multiple languages. Fortunately, enhancements to Power BI over the last year have reduced this challenge making it more attainable to Power BI content creators. As an example, Power BI added support for the USERCULTURE function which provides the ability to write measures which implement report label translations dynamically. Power BI enhancements to the report designer now provide more flexibility to bind measures with dynamic translations to visuals and shapes so they can be surfaced on report pages. Furthermore, the recent introduction of Field Parameters in Power BI now offers a far more elegant and efficient strategy to implement data translations.

In this Livestream session, Ted Pattison will discuss how to get started with multi-language report development. Attendees will learn about the three different types of translations involved with multi-language report development as well as the techniques used to implement them. Ted will demonstrate using the Translations Builder utility to automate repetitive localization tasks that would take forever to complete manually. This session will provide content creators using Power BI Desktop with a better understanding of how all the pieces fit together and with a path forward for building multi-language reports in Power BI using a strategy that is reliable, predictable and scalable.

GUEST BIO 👤

Ted Pattison worked as an independent trainer and software developer whose community efforts earned him the Microsoft MVP award for 15 years in a row. Ted joined the Power BI Customer Advisory Team (PBICAT) at Microsoft in 2020 where he provides guidance to enterprise customers and ISVs in several areas including developing with Power BI embedding, programming with the Power BI APIs and building multi-language reports.

Ted is also the creator of Power BI Dev Camp (https://www.powerbidevcamp.net) which provides a monthly webinar geared toward professional software developers working with Power BI, Fabric and the Microsoft Data Platform.

RELATED CONTENT 🔗

Building Multi-language Reports (Guidance Doc)
Building Multi-language Reports (Hands-on Lab)
Building Multi-language Reports (YouTube Video)
Building Multi-language Reports - Part 2 (YouTube Video)
Translations Builder Utility on GitHub
Live Sample of Multi-language Report

(Livestream Replay) 5 Ways to Get Power BI Data into Excel! None are Copy Paste! - with Wyn Hopkins

ABSTRACT 📄

The reality is folks need / want their data in Excel at some point. While Power BI reduces that need, it still exists. Wyn’s demos will show how to connect using various approaches including a trick to create a connected table with the help of “create formatted table” feature of Power BI, and the largely unknown Featured Table option.

GUEST BIO 👤

Wyn Hopkins is a Microsoft MVP, trainer, consultant and author of the book “Power BI for the Excel Analyst”

Based in Perth, Western Australia, Wyn is the director of the Power BI and Excel consulting firm “Access Analytic”. Their YouTube channel has 40,000+ subscribers and he co-runs the Perth Power BI and Modern Excel meetup group. Once upon a time Wyn was a chartered Accountant with PriceWaterhouseCoopers but Wyn and team now spend their time delivering Power BI and Excel training along with reporting solutions for clients of all industries and sizes. Wyn’s claim to fame is that he suggested and campaigned for the creation of the XLOOKUP function.

RELATED CONTENT 🔗

Wyn's Book & Website
Wyn's Company Website
Wyn's Social Media Links

New Relationship Pane Walkthrough for Power BI Desktop

Video by: Reid Havens

Let's review the NEW relationship Pane (in preview as of February 2023) that can be found in the Model View for Power BI Desktop! We'll compare it to the traditional relationship pop up window as well! Tune in to learn more.

Introduction to Using URLs for Reports in Power BI!

Video by: Reid Havens

Learn how to add either dynamic or fixed URL links in Power BI. This video will review tables, matrixes, and other objects where you can add URL hyperlinks. Tune in to learn more!