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

(Livestream Replay) Inside Bravo for Power BI - with Marco Russo

ABSTRACT 📄

Explore the features available in Bravo for Power BI: Analyze Model, Format DAX, Manage Dates, and Export Data. In particular, we will see how it is possible to customize and deploy a date table for an entire organization!

GUEST BIO 👤

Marco Russo wrote several books about DAX and data modeling for Power BI and Analysis Service with Alberto Ferrari. Marco regularly publishes new content on sqlbi.com and teaches DAX around the world.

RELATED CONTENT 🔗

Bravo for Power BI
SQLBI Website
Marco's Twitter
Marco's LinkedIn

(Livestream Replay) [DAX] Window Functions & Tabular Editor 3 - with Daniel Otykier

ABSTRACT 📄

The Power BI December 2022 update included some exciting new DAX functions, that are all the buzz recently. Let’s explore these new functions using Tabular Editor 3’s DAX debugger to see what we can learn from them.

GUEST BIO 👤

Daniel is a Microsoft Data Platform MVP and CTO of Tabular Editor ApS – the company behind the tool. Tabular Editor is a popular tool for managing and editing Microsoft Power BI, Analysis Services, and Azure Analysis Services models. With a background in data analysis and business intelligence, Daniel has a strong understanding of the challenges and needs of BI professionals. He developed the Tabular Editor as a solution to streamline the process of managing and editing tabular models, and it has since become a go-to tool for many in the industry.

RELATED CONTENT 🔗

Tabular Editor Site
Daniel's Twitter
New DAX Functions (Dec ‘22 Power BI Release)