RSSAmplifier

Blog

Evaluation Context

A blog about the Microsoft BI stack (Microsoft Fabric, Power BI, SQL, SSAS, DAX)

evaluationcontext.github.ioRSS feed ↗52 posts

Latest posts

Contributing to DaxLib

How to contribute a Library to DaxLib

Blogging in Numbers

A year and half of blogging, in numbers

DAX Performance Tuner MCP Server

Using the DAX Performance Tuner MCP Server to improve the performance of the Daxlib.SVG.Compound.Violin() function

DaxLib.SVG 0.2.3

DaxLib.SVG v0.2.3-beta release

Fabric-CICD Updates - Semantic Models, Parameters and Config

A look at recent updates to fabric-cicd including semantic model binding, response collection, and YAML configuration

Fabric-CICD - It's Official

Fabric-cicd hits v0.2.0 with official Microsoft support, long-term roadmap commitment, and deep Fabric platform integration

DaxLib.SVG 1.0.1

DaxLib.SVG v1.0.1 release

SVG Rendering Cost in Power BI

Investigation the factors that affect SVG rendering performance in Power BI

CICD for Fabric Data Teams

Bring software engineering rigor to modern data teams using Microsoft Fabric

Musings on Agentic Development in Fabric

Reflections from an agentic development project

Dynamic Data Masking in Power BI

Secure dynamic data masking in Power BI Import Models

Fabric App Documentation Site

Building a documentation site with a static site generator (Zensical), served as a Fabric App via Rayfin

DaxLib.SVG 2.0.0

DaxLib.SVG v2.0.0 release

DaxLib.SVG Compound Function Performance

Testing the query performance of DaxLib.SVG Compound functions with the DAX Performance Testing Notebook

Fabric Graphs

Can you use Fabric Graph To Analyze User Permissions to Fabric Items

Calendar-Based Time Intelligence Is Out Of This World

Darian Calendar using Calendar-Based Time Intelligence

DAX UDF Library AutoDocs

Auto generate docs for DAX UDF libraries

DaxLib.SVG

DaxLib.SVG v0.2.0-beta release

DAX UDF Colour Library

A DAX UDF colour library to manipulate HEX colours

DAX Highlighting in Github Pages

DAX Syntax Highlighting on GitHub Pages with Rouge and highlight.js

Considering Cardinality of Column Combinations in Junk Dimension Design

Evaluating the design of Junk Dimension via calculating the Cardinality of Column Combinations

TOPN vs INDEX

Rewriting a DAX query that uses TOPN with INDEX to investigate ease of use and performance characteristics

Solving the Islands Problem in DAX

Solving the Island problem in DAX, to return a list of continuous Dates

VS Code Extensions For Power BI Development and Administration

VS Code extension for Power BI Development and Administration

The Delta Between a Lake and Lakehouse

How does Delta Lake Uplift a Data Lake to a Lakehouse

Using Git Submodules to Distribute a Common Theme to Power BI Reports

Defining a Theme in a Git Submodule that can be injected into Reports in other repos upon deployment

SVG Dumbbell Chart in Power BI

Using DAX to create a SVG Dumbbell chart in Power BI

Further Adventures in SVGs

Creating a Trend SVG Visual in Power BI

SVG Heatmap

Creating a Heatmap SVG to visualize distributions

SVG Violin Plot

Creating a SVG Violin to visualize distributions in Power BI

Stealing Performance from Sparklines

Using the ad hoc measures created by sparklines to optimize SVG generating measures

Optimizing the SVG Heatmap

Optimizing the SVG Heatmap using the Sparkline measure pattern

Visualizing Power BI Visual Performance

Using Power BI Logs, Report metadata and SVG to visual visual performance and usage with a page heatmap

Keeping Power BI Incremental Refresh Up To Date

A alternate solution to a solution by Nikolaos Christoforidis for keeping local Incremental Refresh Reports up to date

Deneb Gantt Chart

Using Deneb and Vega-Lite to create a Gantt Chart if Power BI

Vega Embed

Installing and using Vega Embed on my Blog

Who Actually Has Access To What In Power BI?

Using Power BI Scanner and GraphFrames to figure out who can access what in Power BI tenant

Visualizing Power BI Permission Inheritance

Using Deneb Force Directed Graph to visualizing the inheritance of Power BI permission

Graphing DAX Query Plans

Using Vega Force Directed Graphs to visualizing DAX Query Plans

Label Propagation To Identify End User Persona?

Using Label Propagation to attempt to obtain cluster of users that can used to define personas, to simplify granting of permissions

Exporting Power BI Tenant Settings

Exporting Power BI Tenant Settings with the Fabric List Tenant Settings API

Incremental Refresh on Slowly Changing Dimension in Power BI

Incremental Refresh on Slowly Changing Dimension in Power BI

Minimizing SVG Strings to Avoid Hitting Power BI Memory Limits

Minimizing SVG Strings to Avoid Hitting Power BI Memory Limits

Vertipaq Analyzer, Deep Dive

Exploring how Semantic Link Labs and SQLBI's Vertipaq Analyzers work

Monitoring for Power BI Admins

What is going on in your Power BI Tenant?

Fabric-cicd, Kicking the tyres

Open Source Python Library for Fabric Deployments

From Wrist to Dashboard - Real-Time Dashboards in Fabric

Real-time streaming of heart rate data from Garmin watch to Microsoft Fabric

One Pipeline to Rule Them All

Consolidating Fabric Deployment Pipelines in Azure DevOps

Smarter Subgraphs - Kusto as a Engine For Power BI

Move beyond VertiPaq's limitations. Using Kusto Database with Direct Query and motif matching to create dynamic, clean, and performant graph visual in Power BI

Translytical Sudoku

Sudoku in Power BI using Translytical Task Flows