Power BI Datamarts First Impressions

My first impressions of the Power BI Datamarts feature announced at Microsoft Build 2022.

Introduction to hierarchies in Analysis Services and Power BI

A look at what hierarchies are and how they're used within the context of Analysis Services and Power BI, and some practical examples on how to implement them.

KPIs #2: Developing KPIs in Power BI and Analysis Services using Tabular Editor

Some further observations when developing KPIs witin Power BI and Analysis Services.

KPIs #1: KPI usage in Analysis Services, Excel Power Pivot, and Power BI 🚦

An introduction to the KPIs feature in Analysis Services and how you're able to use them in Power BI.

Creating a date table in Power Query

How to make a date table in Power Query’s M language and what fields I think are important to include.

Workarounds for Analysis Services database admins without server admin access

I take a look at some limitations that database admins face when administering their Analysis Services databases without having server admin access and provide some workarounds for common issues.