Walk-through

Jan 1810 min read

Setting up RLS on a Direct Lake semantic model

Power BI semantic models have the option to set up row level security (RLS). And this includes Direct Lake Power BI semantic models in...

4,939 views0 comments

Jul 10, 20236 min read

Generate a Power BI Direct Lake data model in Fabric

One of the cool things about having a notebook inside a Power BI workspace is all the cool things pyspark can do. I wanted a way to...

Jul 31, 20212 min read

DAX Date Table

There are a lot of different Date tables out there, and this is mine! This one features things I add in many of my reports, which is a...

1,779 views

Jun 10, 20214 min read

Report overlay to highlight report features

When I show a report to someone, I find myself pointing to parts of the report and explaining what they do, here I add an overlay to do it.

1,567 views0 comments

Apr 10, 20213 min read

Buttons to highlight a selected measure!

Use buttons to highlight which selected measure is being used!

1,849 views0 comments

Jan 30, 20214 min read

Working with DateID in Direct Query and Incremental Refresh

Scenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat

Dec 20, 20203 min read

Creating a slicer panel!

Many of my reports feature the slicer panel that hide/show on via a button.

1,249 views0 comments

Dec 4, 202011 min read

Let's create a data model!

Tabular data modeling is key to making a report, and can be daunting at first. I'll show you how I approach making a tabular data model....