If you have a DirectQuery fact table in Power BI you can use user-defined aggregations to improve query performance; querying a smaller, summarised copy of your data in an Import mode aggregation ...

Power BI has become an indispensable tool for businesses looking to transform raw data into actionable insights. But here’s the thing: those insights are only as good as the data they’re built on. If ...

Olist is a Brazilian e-commerce marketplace that connects small businesses to major online marketplaces. This project takes ~100K real, anonymized orders (2016–2018) across 9 raw CSV tables — orders, ...

A live, DirectQuery-connected Power BI dashboard built to track sales orders, customer performance, and reserved inventory across the Saudi Arabia (KSA) market for an FMCG business, sourced from a ...

This module is provided at an Advanced level and is perfect for stepping up after mastering basic operations. Performance is extremely important because it leads to these issues. Especially for ...

In last week’s post I mentioned that while Power BI reports (unlike Excel PivotTables) do not support the Detail Rows Expression feature, it is possible to partially work around this limitation by ...