If you are not a C# Jedi, trying to write C# scripts for Tabular Editor in Tabular Editor 2 is quite of a challenge. At least it was for me. With time I found out how to bring development over to Visual Studio, and how to bring the code back easily into tabular Editor. In this session I demo how to set up the environment and start coding away in a much more confortable way with the help of GitHub Copilot.

Discover the potential of scripts and programmatic access to semantic model metadata. Get inspiration about what's possible, and take home specific examples that can boost your productivity. In this session, Daniel will assume the role of a data modelling wizard, throwing incantations and spells in the form of Tabular Editor C# scripts that can generate model documentation, clean up your model, and unlock advanced DAX modelling techniques that would otherwise be extremely tedious and time consuming.

Présentation des Calculation Groups et de leur utilisation pour répondre à des cas d'usages métiers tels que la gestion des calculs temporels, la modélisation des 'role-playing dimensions', la segmentation dynamique et la reproduction du comportement des colonnes calculées DAX dynamiques.

Les Calculation Groups (groupes de calculs) sont disponibles depuis 2018. D'abord via Tabular Editor (outil externe gratuit) puis en natif dans Power BI Desktop en 2023. Ces groupes de calculs sont une arme redoutable pour améliorer votre code DAX et mieux le factoriser. Au cours de cette session, Tristan Malherbe vous montrera comment les utiliser pour répondre à des cas d'usages métiers fréquemment rencontrés: gestion des calculs temporels, modélisation des role-playing dimension, segmentation dynamique et reproduction du comportement de colonnes calculées DAX dynamiques.

You do not rise to the level of your goals, you fall to the level of your systems. In this session, you'll get hands-on methods for making documentation a natural part of your Power BI workflow. We'll explore Power Query metadata, Table Groups and scripting in Tabular Editor, INFO.VIEW DAX functions, external tools, model layout views, VertiPaq Analyzer in DAX Query views, Semantic Link Labs, and JSON theme documentation. Everything is tied together in a user-friendly, accessible app – where the end user meets the documentation directly. This isn’t just inspiration – it’s a system you can take home and apply. A Power BI documentation system – not just an afterthought.

Discussion of CI/CD concepts for Power BI and why they matter for developers, including demos and techniques with internal Power BI features and external tools such as Tabular Editor, Azure DevOps, and Fabric APIs; aims to enable mature, scalable deployment and multi-developer collaboration.

Live demo to use Data Factory in Microsoft Fabric to build a Power BI report, starting with a Dataflow Gen2 in a Lakehouse, orchestrating its refresh schedule with a Data Pipeline and using Tabular Editor to build the report. Date: 2024-04-24. Starts at 7 PM CET via MS Teams.

In this session we will cruise through some of the features that makes Tabular Editor 3 stand out as the best tool to set your semantic modeling on warp speed. This guided galaxy tour, by the inventor himself Daniel Otykier, will take you through features such as the DAX Debugger, the creation of reusable Macros and a galaxy worth of tips to take your data model to the stars.