Blog | DataZoe Power BI

top of page

DataZoe Power BI

Search

Creating a perspective in Power BI Desktop with TMDL view

Creating a perspective in Power BI Desktop with TMDL view

Perspectives in Power BI semantic models

Let's take a look at these perspective topics in this blog post: 1. Hiding vs perspectives, 2. Authoring in Power BI Desktop with TMDL view, 3. Using perspectives in live connect reports in Power BI Desktop, 4. Using perspectives in the Personalized visuals feature, and 5. Analyzing perspectives with a DAX query

5 hours ago7 min read

DAX Date table in Power BI shown in TMDL View

DAX Date table in Power BI shown in TMDL View

DAX Date table in TMDL

My date table now in TMDL with sort by columns, format strings, descriptions, folders, and hierarchy.

Feb 175 min read

DEFINE MEASURE in a DAX query of DAX query view in Power BI

DEFINE MEASURE in a DAX query of DAX query view in Power BI

DAX query 102: DAX formulas and measures with DEFINE MEASURE

There is a now a DAX query view in Power BI and let's get you started querying your data with whatever formula you need defined in the...

Feb 167 min read

DAX query 101: Get and analyze data with EVALUATE, FILTER, SELECTCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, ORDER BY, TOPN, START AT, and {table constructors}

DAX query 101: Get and analyze data with EVALUATE, FILTER, SELECTCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, ORDER BY, TOPN, START AT, and {table constructors}

DAX query 101: Get and analyze data with EVALUATE, FILTER, SELECTCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, ORDER BY, TOPN, START AT, and {table constructors}

Let's get you started querying your data to get the analysis you are looking for!

Jan 2616 min read

Keeping up with the Power BI Blog with Power Automate

Keeping up with the Power BI Blog with Power Automate

Keeping up with the Power BI Blog with Power Automate

Before I joined the Power BI product group, I had a friend show me how to have the Power BI blogs show up in a Teams channel. You can...

Jul 12, 20242 min read

Setting up RLS on a Direct Lake semantic model

Setting up RLS on a Direct Lake semantic model

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...

Tabular Data Model

Jan 18, 202410 min read

Relationships DAX query (using INFO.RELATIONSHIPS)

Relationships DAX query (using INFO.RELATIONSHIPS)

Relationships DAX query (using INFO.RELATIONSHIPS)

Surface your relationship metadata with the new DAX INFO functions!

Dec 27, 20236 min read

Generate a Power BI Direct Lake data model in Fabric

Generate a Power BI Direct Lake data model in Fabric

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 10, 20236 min read

Add filter to show current user items or all items

Add filter to show current user items or all items

Add filter to show current user items or all items

I ran into a request recently to filter to current user only items but also allow them to see all items. I at first thought of row-level...

Feb 1, 20221 min read

Same period last year with partial periods

Same period last year with partial periods

Same period last year with partial periods

I was helping a friend today with how do we compare partial month this year to just the same partial month last year scenario. When we...

Oct 25, 20211 min read

DAX Date Table

DAX Date Table

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...

Jul 31, 20212 min read

Report overlay to highlight report features

Report overlay to highlight report features

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.

Jun 10, 20214 min read

Allowing your end users to Refresh Power BI data with Power Automate

Allowing your end users to Refresh Power BI data with Power Automate

Allowing your end users to Refresh Power BI data with Power Automate

There are some reports where I have a schedule refresh but I also want to bring in new data whenever I happen to be looking at the...

May 2, 20212 min read

Buttons to highlight a selected measure!

Buttons to highlight a selected measure!

Buttons to highlight a selected measure!

Use buttons to highlight which selected measure is being used!

Apr 11, 20213 min read

Switch between fiscal and regular calendar via slicer

Switch between fiscal and regular calendar via slicer

Switch between fiscal and regular calendar via slicer

I recently answered a request for this on the Power BI Community forums and thought I would share how to implement this in more detail....

Feb 26, 20214 min read

Working with DateID in Direct Query and Incremental Refresh

Working with DateID in Direct Query and Incremental Refresh

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

Jan 30, 20214 min read

Creating a slicer panel!

Creating a slicer panel!

Creating a slicer panel!

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

Dec 20, 20203 min read

Let's create a data model!

Let's create a data model!

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....

Dec 4, 202011 min read

Power BI Buttons - Page Navigation with Icons

Power BI Buttons - Page Navigation with Icons

Power BI Buttons - Page Navigation with Icons

I find buttons to have a variety of uses in Power BI! This button technique shows you how to add an icon based button for page navigation...

Nov 29, 20202 min read

Careful with RangeEnd with Incremental Refresh

Careful with RangeEnd with Incremental Refresh

Careful with RangeEnd with Incremental Refresh

Lately I've been working with incremental refresh and found that while RangeStart changes with the settings for incremental refresh the...

Nov 2, 20201 min read

bottom of page