If you are starting to enjoy using Microsoft Fabric more, especially the exciting new Direct Lake storage mode, you may find this simple tip useful to help monitor your semantic models. The idea behind this tip is to run a DMV (can be any DMV) on a regular basis against a semantic-model and accumulate results … Continue reading Use Fabric Notebook to monitor Power BI semantic models| Phil Seamark on DAX
I recently needed to generate a quick visual inside a Microsoft Fabric notebook. After a little internet searching, I found there are many good quality charting libraries in Python, however it was going to take too long to figure out how to create a very specific type of chart. This is where Vega came to … Continue reading Create charts using Vega in Microsoft Fabric Notebook| Phil Seamark on DAX
I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function. The … Continue reading DAX Pareto Calculation The post DAX Pareto Calculation appeared first on Phil Seamark on DAX.| Phil Seamark on DAX
This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations The post Speed up Distinct Count calculations in Power BI using Aggregations...| Phil Seamark on DAX
Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are … Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop The post Using PowerShell to create Calculation Groups in Power BI Desktop appeared fi...| Phil Seamark on DAX
Introduction How to choose the correct storage mode for Power BI Tables. This article aims to help explain the different storage modes available when designing an aggregation strategy for a Power BI Report. What each storage mode is and when you would use it. Picking the correct storage mode for each table in your model … Continue reading Power BI Storage Modes for Aggregations The post Power BI Storage Modes for Aggregations appeared first on Phil Seamark on DAX.| Phil Seamark on DAX
Part two in this series on Power BI Aggregation tables focuses on Power BI data models with more than one aggregation table. The first article introduced Power BI Aggregations and included a walk through configuring a Power BI model with a single aggregation table. Intro to Power BI Aggregations Multiple aggregations tables DUAL storage mode … Continue reading Power BI Multiple Aggregations tables The post Power BI Multiple Aggregations tables appeared first on Phil Seamark on DAX.| Phil Seamark on DAX
This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article … Continue reading Intro to Power BI Aggregations The post Intro to Power BI Aggregations appeared first on Phil Seamark on DAX.| Phil Seamark on DAX
A walk through on how to build a measure in Power BI that lets you group and count the last known state for a given set of items| Phil Seamark on DAX
A few blogs back I shared a technique using Power BI Profiler (or VS Code) to run and capture a trace over a refresh of a Power BI semantic model (the object formally known as a dataset). I’ve since received a lot of positive feedback from people saying how useful it was to visualize each … Continue reading Visualize Power BI Refresh using Semantic-link| Phil Seamark on DAX
