(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

[DAX] Dynamic Format Strings WITHOUT Calculation Groups ?!?

Video by: Reid Havens

Learn how to add Dynamic Format Strings for individual [DAX] measures in Power BI! This technique doesn’t require calculation groups or Tabular Editor either, and can be done entirely inside of Power BI desktop.

Side note, if you aren’t using Tabular Editor as a model developer you should be. It’s a fantastic tool for any intermediate to advanced modeling scenarios, and the only way to add calculation groups (today).

RELATED CONTENT 🔗

Dynamic Format Strings in DAX
Kane Snyder’s Linkedin Post
Tabular Editor

Hiding Measures from [DAX] Intellisense!

Video by: Reid Havens

When creating datasets with build permissions (shared datasets), many of us know to hide fields from the data pane. But did you know you can also "hide" measures from the intellisense list in DAX? In this video learn how to use tabular to configure a table property to hide any measures inside of that table, from any DAX intellisense when writing measures. Further increasing usability when creating shared datasets in the Power BI service!

PLEASE NOTE this is not (officially supported) by Microsoft. But is a relatively safe setting to modify. Just be aware Microsoft doesn't provide support for this. More info below at the tabular editor link

RELATED CONTENT 🔗

Data Goblin Report Layer Article
Tabular Editor Private Setting

(Livestream Replay) Introducing TMDL for Power BI! - with Mathias Thierbach

ABSTRACT 📄

An early look at the Tabular Model Definition Language (TMDL), soon to be released by Microsoft as a public preview as part of the Tabular Object Model (TOM) libraries. TMDL was first presented at SQLBits in March 2023 and is the first of several new innovations and tools targeting the needs of Power BI Pro Developers.

It consists of new declarative format for tabular models, designed for readability and editability, as well as a standardized folder structure for those files (similar to tabular Editor's "Save-to-folder" format), enabling collaborative workflows. Mathias has implemented TMDL as part of the Power BI Contributor Program. He will present the key aspects of the language as well as its main benefits.

GUEST BIO 👤

Mathias is a Data Platform MVP and Head of Finance Systems at YouGov in London. He cares deeply about mature enterprise-grade development and delivery patterns and practices for Power BI. To that end, he has developed pbi-tools, which was released as an open source tool in October 2021. Furthermore,

Mathias has presented his learnings and best practices around Power BI DataOps, CI/CD, and Deployment Automation, but also talks on the organizational and managerial aspects of running a successful Poewr BI team at several international conferences and many user groups.

RELATED CONTENT 🔗

Mathias's Twitter
Mathias's LinkedIn
PBI Tools