Welcome to the November 2023 update.   We have lots of features this month including Narrative visual with Copilot, cross workspace “save as” for Data Factory, the general availability of Semantic...

Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a st

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an O

Marco Russo's answer: I know many people who love DAX, but I think to know some of the reasons why many others don’t like it. DAX has a simple syntax inherited from Excel. However, DAX is a language...

The ultimate reference for Power BI charts and visuals. Microsoft Power BI is a great tool to create Business Intelligence reports, and it includes several

DAX Studio is a tool to write, execute, and analyze DAX queries in Power BI Designer, Power Pivot for Excel, and Analysis Services Tabular. It includes an O

In this post, we look at what we can do to make our datasets easier to use, understand & maintain.

Years ago, when Data Warehouses were still roaming the earth*, we called it ETL Developer. ETL stands for Extract, Transform, Load. We extract the data from the source systems (such as ERP, finance…

Whilst data lakes are great for data science and machine learning, they are not good for BI and reporting. Poor data quality, duplicate data, missing data, no foreign keys, no NULL checks, the list…

This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity an

Let me start by thanking Ralph Kimball for inventing the dimensional modelling techniques back in 1996. And also thanks to the rest of the Kimball Group especially Margy Ross, Bob Baker, Warren Tho…

This article describes how to implement a syntax equivalent to the T-SQL function NULLIF and the ANSI SQL function COALESCE, in DAX. As do many languages, D

Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models

In December 2022, DAX was enriched with window functions: INDEX, OFFSET, and WINDOW. This article introduces the syntax and the basic functionalities of the

This article describes how to optimize a slow Power BI report with a large number of card visuals, by obtaining the same graphical layout with a smaller num

Another year has gone by and it has now been 10 years since DAX was first introduced in late 2009. As usual, it is time to review the past year and to take

The ultimate reference for Power BI charts and visuals. Microsoft Power BI is a great tool to create Business Intelligence reports, and it includes several

We’re excited to announce new capabilities that make it easier for users to add Power BI data to their Excel workbooks. We’re adding an Insert Table option directly in Excel. We’re also adding an...

New Features (Preview) Query Builder (Preview) Query Benchmark #314 Added Quick Access buttons for New, New (with current connection) & Save #277 Added Export button to all trace outputs Added...

Starting from the May 2020 version of Power BI Desktop, regardless of the Windows locale settings DAX always uses standard separators by default. This chang

Almost exactly one year ago, we saw the first glimpse of Tabular Editor 3 on this channel! Half a year ago, the tool was publicly released. In this session, ...