Data Meerkat
  • Home
  • Templates
  • Cheatsheets
  • About

Recent content

Fabric Notification Bot for Microsoft Teams
17 Apr 2025

Fabric Notification Bot for Microsoft Teams

Write your data into Lakehouse by Notebooks
10 Mar 2025

Write your data into Lakehouse by Notebooks

Orchestration Fabric Notebooks
11 Oct 2024

Orchestration Fabric Notebooks

GraphQL in Microsoft Fabric
12 Jul 2024

GraphQL in Microsoft Fabric

Popular topics

admin api azure calculation_groups color comments conditional_formatting copy_activity data_driven data_extraction data_storytelling dataflow date dax development dimension documentation domains excel extraction fabric field_parameters format_string governance graphql hierarchies index integration json list m markdown measure monitoring notebook notebooks offset orchestration performance power_automate power_query powershell pyspark python rankx record rest_api rownumber service sharepoint svg template topn typescript visual window
Admin

admin

6 Posts
Personal Workspaces in Times of Fabric
Štěpán Rešl
admin api service governance fabric

Personal Workspaces in Times of Fabric

From time to time, there is a need to talk about the possibilities, benefits, and dark sides that personal workspaces, aka "My workspace," bring.

Domains
Štěpán Rešl
admin api rest_api service monitoring domains

Domains

As your Power BI / Microsoft Fabric Service grows, the need arises for you to be able to divide the content in a little more detail (e.g., which division/department should have access to the given data)

Dataflows refresh monitoring
Štěpán Rešl
power_automate api dataflow admin monitoring

Dataflows refresh monitoring

Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.

Restrict Power BI Integration Button in Microsoft Lists
Štěpán Rešl
integration service admin sharepoint

Restrict Power BI Integration Button in Microsoft Lists

Power BI and integration to Sharepoint Lists have been with us for some time. Some can turn them on, or only specific groups of users can access them. But what to do if we have an open company policy so that everyone can use it, but then we have a specific List for which we would instead not show the integration? A JSON schema definition will help us.

Power Query vs. Power BI Rest API
Štěpán Rešl
m power_query rest_api admin azure

Power Query vs. Power BI Rest API

The Power BI Service hides data that is not visible at first peek but can help us control the Service and properly check whether there are any irregularities. It may sound a bit recursive, but let's get this data into Power BI using Power Query so we can start creating reports from it. Why to leave your favorite tool when there is no need for that at all.

Rebinding Power BI Reports to Different Dataset
Štěpán Rešl
admin service rest_api powershell

Rebinding Power BI Reports to Different Dataset

Duplicate Power BI Dataset, from which colleagues have already managed to make their reports? Doesn't that sound scary? Personally yes!

Api

api

9 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

GraphQL in Microsoft Fabric
Štěpán Rešl
graphql fabric api development

GraphQL in Microsoft Fabric

GraphQL is a query language specification that allows users to define the structure of data to be returned from an API.

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists
Štěpán Rešl
fabric sharepoint dataflow copy_activity notebook api

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists

Excel is not a database... so Sharepoint is not a database. But that doesn't mean that people don't use it that way often, and even if they don't, we need to get the data out of them to use it.

Personal Workspaces in Times of Fabric
Štěpán Rešl
admin api service governance fabric

Personal Workspaces in Times of Fabric

From time to time, there is a need to talk about the possibilities, benefits, and dark sides that personal workspaces, aka "My workspace," bring.

Lessons learnt from PySpark Notebooks and extracting APIs
Štěpán Rešl
fabric notebook pyspark markdown api

Lessons learnt from PySpark Notebooks and extracting APIs

PySpark Notebooks inside Fabric are a high-speed solution for data transformation. But what about their ability to get data from the API?

Domains
Štěpán Rešl
admin api rest_api service monitoring domains

Domains

As your Power BI / Microsoft Fabric Service grows, the need arises for you to be able to divide the content in a little more detail (e.g., which division/department should have access to the given data)

Execute Query endpoint - Get your data from datasets
Štěpán Rešl
dax api rest_api power_automate development data_extraction

Execute Query endpoint - Get your data from datasets

The fact that I have data in Power BI does not end the story. This is the start of a new one!

Dataflows refresh monitoring
Štěpán Rešl
power_automate api dataflow admin monitoring

Dataflows refresh monitoring

Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.

APIs as Power BI Datasources
Štěpán Rešl
m power_query api

APIs as Power BI Datasources

There is an abundance of APIs around us, and we use them in our daily routine without thinking about them anymore.

Azure

azure

2 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Power Query vs. Power BI Rest API
Štěpán Rešl
m power_query rest_api admin azure

Power Query vs. Power BI Rest API

The Power BI Service hides data that is not visible at first peek but can help us control the Service and properly check whether there are any irregularities. It may sound a bit recursive, but let's get this data into Power BI using Power Query so we can start creating reports from it. Why to leave your favorite tool when there is no need for that at all.

Calculation_groups

calculation_groups

7 Posts
Combining Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting rownumber data_storytelling visual

Combining Calculation Groups

Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.

Dynamic windows in calculation groups
Štěpán Rešl
dax calculation_groups field_parameters window

Dynamic windows in calculation groups

The WINDOWS function is becoming very popular because it can save a lot of time both for the execution of the calculation and for the development itself. At the same time, this is the last of the new functions I need to test against Calculation Groups.

INDEX as a friend for Conditional Format Strings
Štěpán Rešl
dax calculation_groups format_string conditional_formatting index

INDEX as a friend for Conditional Format Strings

INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers

OFFSET and its usage with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting offset

OFFSET and its usage with Calculation Groups

December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation with Calculation Groups.

Multi-Color Gradient with DAX in Power BI
Štěpán Rešl
dax calculation_groups conditional_formatting color

Multi-Color Gradient with DAX in Power BI

There are more than just many visual elements and their use in Power BI.Many of them are natively, and you have to create them yourself. One such specialty that you need to create yourself is the Multi-Color gradient. It can help us with that as it happens... DAX and slight bending of other elements and options that Power BI provides.

Conditional Formatting with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting

Conditional Formatting with Calculation Groups

The second part of this series is focused on conditional formatting and calculation groups. Because calculation groups are a fascinating component in the entire Power BI ecosystem, it would be a shame not to use them occasionally for graphic purposes.

Field parameters in cooperation with Calculation groups
Štěpán Rešl
dax calculation_groups field_parameters conditional_formatting

Field parameters in cooperation with Calculation groups

As soon as I saw the field parameters, I was very interested in the possibilities of use with calculation groups and their mutual overlap. So I finally got to writing my findings from testing the two features together.

Color

color

1 Posts
Multi-Color Gradient with DAX in Power BI
Štěpán Rešl
dax calculation_groups conditional_formatting color

Multi-Color Gradient with DAX in Power BI

There are more than just many visual elements and their use in Power BI.Many of them are natively, and you have to create them yourself. One such specialty that you need to create yourself is the Multi-Color gradient. It can help us with that as it happens... DAX and slight bending of other elements and options that Power BI provides.

Comments

comments

1 Posts
Documentation options in Power Query
Štěpán Rešl
m power_query documentation comments development

Documentation options in Power Query

Document your code! One day you will thank yourself, or someone else will thank you, who will take over.

Conditional_formatting

conditional_formatting

8 Posts
Combining Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting rownumber data_storytelling visual

Combining Calculation Groups

Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.

INDEX as a friend for Conditional Format Strings
Štěpán Rešl
dax calculation_groups format_string conditional_formatting index

INDEX as a friend for Conditional Format Strings

INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers

OFFSET and its usage with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting offset

OFFSET and its usage with Calculation Groups

December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation with Calculation Groups.

Multi-Color Gradient with DAX in Power BI
Štěpán Rešl
dax calculation_groups conditional_formatting color

Multi-Color Gradient with DAX in Power BI

There are more than just many visual elements and their use in Power BI.Many of them are natively, and you have to create them yourself. One such specialty that you need to create yourself is the Multi-Color gradient. It can help us with that as it happens... DAX and slight bending of other elements and options that Power BI provides.

Conditional Formatting with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting

Conditional Formatting with Calculation Groups

The second part of this series is focused on conditional formatting and calculation groups. Because calculation groups are a fascinating component in the entire Power BI ecosystem, it would be a shame not to use them occasionally for graphic purposes.

Conditional Formatting based on Field Parameters
Štěpán Rešl
dax field_parameters format_string conditional_formatting

Conditional Formatting based on Field Parameters

Conditional formatting. It can sometimes seem like magic, what a few colors that appear at the right moment can do. Of course, the same applies to text, labels, and the like. However, with the advent of field parameters, it became necessary to look at the issue of conditional formatting from different perspectives. For example, how to prepare it for a particular scenario, should the user have the option of single-selection or multi-selection within the parameter, and whether we help anything with the formatting?

Hierarchies with dynamic levels in Matrix by Field Parameters
Štěpán Rešl
dax field_parameters hierarchies conditional_formatting

Hierarchies with dynamic levels in Matrix by Field Parameters

Hierarchies are the bread and butter of Power BI. We've probably all come across that the Matrix within the hierarchy often displays empty values ​​where the hierarchy does not continue to the same levels or that the "+/-" icon appears even when we don't want it to.

Field parameters in cooperation with Calculation groups
Štěpán Rešl
dax calculation_groups field_parameters conditional_formatting

Field parameters in cooperation with Calculation groups

As soon as I saw the field parameters, I was very interested in the possibilities of use with calculation groups and their mutual overlap. So I finally got to writing my findings from testing the two features together.

Copy_activity

copy_activity

1 Posts
Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists
Štěpán Rešl
fabric sharepoint dataflow copy_activity notebook api

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists

Excel is not a database... so Sharepoint is not a database. But that doesn't mean that people don't use it that way often, and even if they don't, we need to get the data out of them to use it.

Data_driven

data_driven

1 Posts
Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?
Štěpán Rešl
power_automate rest_api service data_driven

Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?

At the end of last year, one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API. It is an endpoint that allows you to extract data directly from datasets.

Data_extraction

data_extraction

2 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Execute Query endpoint - Get your data from datasets
Štěpán Rešl
dax api rest_api power_automate development data_extraction

Execute Query endpoint - Get your data from datasets

The fact that I have data in Power BI does not end the story. This is the start of a new one!

Data_storytelling

data_storytelling

3 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Combining Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting rownumber data_storytelling visual

Combining Calculation Groups

Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.

SVG options in Matrix
Štěpán Rešl
dax visual svg data_storytelling

SVG options in Matrix

Dynamic design using SVG? Sure! Here we go.

Dataflow

dataflow

2 Posts
Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists
Štěpán Rešl
fabric sharepoint dataflow copy_activity notebook api

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists

Excel is not a database... so Sharepoint is not a database. But that doesn't mean that people don't use it that way often, and even if they don't, we need to get the data out of them to use it.

Dataflows refresh monitoring
Štěpán Rešl
power_automate api dataflow admin monitoring

Dataflows refresh monitoring

Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.

Date

date

1 Posts
Date dimensions in Power Query
Štěpán Rešl
m power_query date dimension

Date dimensions in Power Query

The date dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the point of view of the passage of time.

Dax

dax

13 Posts
Combining Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting rownumber data_storytelling visual

Combining Calculation Groups

Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.

Number of Measures Matters
Štěpán Rešl
dax development performance measure

Number of Measures Matters

Measures are a crucial component in Power BI. But can we have an unlimited number of them?

Execute Query endpoint - Get your data from datasets
Štěpán Rešl
dax api rest_api power_automate development data_extraction

Execute Query endpoint - Get your data from datasets

The fact that I have data in Power BI does not end the story. This is the start of a new one!

SVG options in Matrix
Štěpán Rešl
dax visual svg data_storytelling

SVG options in Matrix

Dynamic design using SVG? Sure! Here we go.

The dynamic ratio of top X products to the rest
Štěpán Rešl
dax rankx topn visual

The dynamic ratio of top X products to the rest

It would be best to give users different data exploration options when creating analytical views. This is one of the practical options.

Dynamic windows in calculation groups
Štěpán Rešl
dax calculation_groups field_parameters window

Dynamic windows in calculation groups

The WINDOWS function is becoming very popular because it can save a lot of time both for the execution of the calculation and for the development itself. At the same time, this is the last of the new functions I need to test against Calculation Groups.

INDEX as a friend for Conditional Format Strings
Štěpán Rešl
dax calculation_groups format_string conditional_formatting index

INDEX as a friend for Conditional Format Strings

INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers

OFFSET and its usage with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting offset

OFFSET and its usage with Calculation Groups

December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation with Calculation Groups.

Multi-Color Gradient with DAX in Power BI
Štěpán Rešl
dax calculation_groups conditional_formatting color

Multi-Color Gradient with DAX in Power BI

There are more than just many visual elements and their use in Power BI.Many of them are natively, and you have to create them yourself. One such specialty that you need to create yourself is the Multi-Color gradient. It can help us with that as it happens... DAX and slight bending of other elements and options that Power BI provides.

Conditional Formatting with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting

Conditional Formatting with Calculation Groups

The second part of this series is focused on conditional formatting and calculation groups. Because calculation groups are a fascinating component in the entire Power BI ecosystem, it would be a shame not to use them occasionally for graphic purposes.

Conditional Formatting based on Field Parameters
Štěpán Rešl
dax field_parameters format_string conditional_formatting

Conditional Formatting based on Field Parameters

Conditional formatting. It can sometimes seem like magic, what a few colors that appear at the right moment can do. Of course, the same applies to text, labels, and the like. However, with the advent of field parameters, it became necessary to look at the issue of conditional formatting from different perspectives. For example, how to prepare it for a particular scenario, should the user have the option of single-selection or multi-selection within the parameter, and whether we help anything with the formatting?

Hierarchies with dynamic levels in Matrix by Field Parameters
Štěpán Rešl
dax field_parameters hierarchies conditional_formatting

Hierarchies with dynamic levels in Matrix by Field Parameters

Hierarchies are the bread and butter of Power BI. We've probably all come across that the Matrix within the hierarchy often displays empty values ​​where the hierarchy does not continue to the same levels or that the "+/-" icon appears even when we don't want it to.

Field parameters in cooperation with Calculation groups
Štěpán Rešl
dax calculation_groups field_parameters conditional_formatting

Field parameters in cooperation with Calculation groups

As soon as I saw the field parameters, I was very interested in the possibilities of use with calculation groups and their mutual overlap. So I finally got to writing my findings from testing the two features together.

Development

development

9 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Write your data into Lakehouse by Notebooks
Štěpán Rešl
fabric python development notebooks pyspark

Write your data into Lakehouse by Notebooks

There are many ways to write data into Lakehouse, even using Notebooks.

Orchestration Fabric Notebooks
Štěpán Rešl
fabric orchestration development notebooks pyspark

Orchestration Fabric Notebooks

How to manage individual notebooks to efficiently utilize shared environment resources?

GraphQL in Microsoft Fabric
Štěpán Rešl
graphql fabric api development

GraphQL in Microsoft Fabric

GraphQL is a query language specification that allows users to define the structure of data to be returned from an API.

Power BI Templates
Štěpán Rešl
template development power_query governance service

Power BI Templates

".pbit" files are well-known in the Power BI world. But this is not the only type of "template" we can encounter. It depends on the scenario we are trying to fulfill.

Number of Measures Matters
Štěpán Rešl
dax development performance measure

Number of Measures Matters

Measures are a crucial component in Power BI. But can we have an unlimited number of them?

Parsing data from JSONs
Štěpán Rešl
m power_query development json record list

Parsing data from JSONs

JSON is one of the most common data file types you'll get back when you try downloading data from an API.

Execute Query endpoint - Get your data from datasets
Štěpán Rešl
dax api rest_api power_automate development data_extraction

Execute Query endpoint - Get your data from datasets

The fact that I have data in Power BI does not end the story. This is the start of a new one!

Documentation options in Power Query
Štěpán Rešl
m power_query documentation comments development

Documentation options in Power Query

Document your code! One day you will thank yourself, or someone else will thank you, who will take over.

Dimension

dimension

1 Posts
Date dimensions in Power Query
Štěpán Rešl
m power_query date dimension

Date dimensions in Power Query

The date dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the point of view of the passage of time.

Documentation

documentation

1 Posts
Documentation options in Power Query
Štěpán Rešl
m power_query documentation comments development

Documentation options in Power Query

Document your code! One day you will thank yourself, or someone else will thank you, who will take over.

Domains

domains

1 Posts
Domains
Štěpán Rešl
admin api rest_api service monitoring domains

Domains

As your Power BI / Microsoft Fabric Service grows, the need arises for you to be able to divide the content in a little more detail (e.g., which division/department should have access to the given data)

Excel

excel

1 Posts
Extraction of Colored Excel Cells
Štěpán Rešl
m power_query extraction excel

Extraction of Colored Excel Cells

Everyone knows that Power Query can get data from individual cells in Excel. But what about only colored cells?

Extraction

extraction

1 Posts
Extraction of Colored Excel Cells
Štěpán Rešl
m power_query extraction excel

Extraction of Colored Excel Cells

Everyone knows that Power Query can get data from individual cells in Excel. But what about only colored cells?

Fabric

fabric

7 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Write your data into Lakehouse by Notebooks
Štěpán Rešl
fabric python development notebooks pyspark

Write your data into Lakehouse by Notebooks

There are many ways to write data into Lakehouse, even using Notebooks.

Orchestration Fabric Notebooks
Štěpán Rešl
fabric orchestration development notebooks pyspark

Orchestration Fabric Notebooks

How to manage individual notebooks to efficiently utilize shared environment resources?

GraphQL in Microsoft Fabric
Štěpán Rešl
graphql fabric api development

GraphQL in Microsoft Fabric

GraphQL is a query language specification that allows users to define the structure of data to be returned from an API.

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists
Štěpán Rešl
fabric sharepoint dataflow copy_activity notebook api

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists

Excel is not a database... so Sharepoint is not a database. But that doesn't mean that people don't use it that way often, and even if they don't, we need to get the data out of them to use it.

Personal Workspaces in Times of Fabric
Štěpán Rešl
admin api service governance fabric

Personal Workspaces in Times of Fabric

From time to time, there is a need to talk about the possibilities, benefits, and dark sides that personal workspaces, aka "My workspace," bring.

Lessons learnt from PySpark Notebooks and extracting APIs
Štěpán Rešl
fabric notebook pyspark markdown api

Lessons learnt from PySpark Notebooks and extracting APIs

PySpark Notebooks inside Fabric are a high-speed solution for data transformation. But what about their ability to get data from the API?

Field_parameters

field_parameters

4 Posts
Dynamic windows in calculation groups
Štěpán Rešl
dax calculation_groups field_parameters window

Dynamic windows in calculation groups

The WINDOWS function is becoming very popular because it can save a lot of time both for the execution of the calculation and for the development itself. At the same time, this is the last of the new functions I need to test against Calculation Groups.

Conditional Formatting based on Field Parameters
Štěpán Rešl
dax field_parameters format_string conditional_formatting

Conditional Formatting based on Field Parameters

Conditional formatting. It can sometimes seem like magic, what a few colors that appear at the right moment can do. Of course, the same applies to text, labels, and the like. However, with the advent of field parameters, it became necessary to look at the issue of conditional formatting from different perspectives. For example, how to prepare it for a particular scenario, should the user have the option of single-selection or multi-selection within the parameter, and whether we help anything with the formatting?

Hierarchies with dynamic levels in Matrix by Field Parameters
Štěpán Rešl
dax field_parameters hierarchies conditional_formatting

Hierarchies with dynamic levels in Matrix by Field Parameters

Hierarchies are the bread and butter of Power BI. We've probably all come across that the Matrix within the hierarchy often displays empty values ​​where the hierarchy does not continue to the same levels or that the "+/-" icon appears even when we don't want it to.

Field parameters in cooperation with Calculation groups
Štěpán Rešl
dax calculation_groups field_parameters conditional_formatting

Field parameters in cooperation with Calculation groups

As soon as I saw the field parameters, I was very interested in the possibilities of use with calculation groups and their mutual overlap. So I finally got to writing my findings from testing the two features together.

Format_string

format_string

5 Posts
Combining Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting rownumber data_storytelling visual

Combining Calculation Groups

Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.

INDEX as a friend for Conditional Format Strings
Štěpán Rešl
dax calculation_groups format_string conditional_formatting index

INDEX as a friend for Conditional Format Strings

INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers

OFFSET and its usage with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting offset

OFFSET and its usage with Calculation Groups

December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation with Calculation Groups.

Conditional Formatting with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting

Conditional Formatting with Calculation Groups

The second part of this series is focused on conditional formatting and calculation groups. Because calculation groups are a fascinating component in the entire Power BI ecosystem, it would be a shame not to use them occasionally for graphic purposes.

Conditional Formatting based on Field Parameters
Štěpán Rešl
dax field_parameters format_string conditional_formatting

Conditional Formatting based on Field Parameters

Conditional formatting. It can sometimes seem like magic, what a few colors that appear at the right moment can do. Of course, the same applies to text, labels, and the like. However, with the advent of field parameters, it became necessary to look at the issue of conditional formatting from different perspectives. For example, how to prepare it for a particular scenario, should the user have the option of single-selection or multi-selection within the parameter, and whether we help anything with the formatting?

Governance

governance

2 Posts
Power BI Templates
Štěpán Rešl
template development power_query governance service

Power BI Templates

".pbit" files are well-known in the Power BI world. But this is not the only type of "template" we can encounter. It depends on the scenario we are trying to fulfill.

Personal Workspaces in Times of Fabric
Štěpán Rešl
admin api service governance fabric

Personal Workspaces in Times of Fabric

From time to time, there is a need to talk about the possibilities, benefits, and dark sides that personal workspaces, aka "My workspace," bring.

Graphql

graphql

1 Posts
GraphQL in Microsoft Fabric
Štěpán Rešl
graphql fabric api development

GraphQL in Microsoft Fabric

GraphQL is a query language specification that allows users to define the structure of data to be returned from an API.

Hierarchies

hierarchies

1 Posts
Hierarchies with dynamic levels in Matrix by Field Parameters
Štěpán Rešl
dax field_parameters hierarchies conditional_formatting

Hierarchies with dynamic levels in Matrix by Field Parameters

Hierarchies are the bread and butter of Power BI. We've probably all come across that the Matrix within the hierarchy often displays empty values ​​where the hierarchy does not continue to the same levels or that the "+/-" icon appears even when we don't want it to.

Index

index

1 Posts
INDEX as a friend for Conditional Format Strings
Štěpán Rešl
dax calculation_groups format_string conditional_formatting index

INDEX as a friend for Conditional Format Strings

INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers

Integration

integration

1 Posts
Restrict Power BI Integration Button in Microsoft Lists
Štěpán Rešl
integration service admin sharepoint

Restrict Power BI Integration Button in Microsoft Lists

Power BI and integration to Sharepoint Lists have been with us for some time. Some can turn them on, or only specific groups of users can access them. But what to do if we have an open company policy so that everyone can use it, but then we have a specific List for which we would instead not show the integration? A JSON schema definition will help us.

Json

json

1 Posts
Parsing data from JSONs
Štěpán Rešl
m power_query development json record list

Parsing data from JSONs

JSON is one of the most common data file types you'll get back when you try downloading data from an API.

List

list

1 Posts
Parsing data from JSONs
Štěpán Rešl
m power_query development json record list

Parsing data from JSONs

JSON is one of the most common data file types you'll get back when you try downloading data from an API.

M

m

6 Posts
Extraction of Colored Excel Cells
Štěpán Rešl
m power_query extraction excel

Extraction of Colored Excel Cells

Everyone knows that Power Query can get data from individual cells in Excel. But what about only colored cells?

Parsing data from JSONs
Štěpán Rešl
m power_query development json record list

Parsing data from JSONs

JSON is one of the most common data file types you'll get back when you try downloading data from an API.

Documentation options in Power Query
Štěpán Rešl
m power_query documentation comments development

Documentation options in Power Query

Document your code! One day you will thank yourself, or someone else will thank you, who will take over.

APIs as Power BI Datasources
Štěpán Rešl
m power_query api

APIs as Power BI Datasources

There is an abundance of APIs around us, and we use them in our daily routine without thinking about them anymore.

Date dimensions in Power Query
Štěpán Rešl
m power_query date dimension

Date dimensions in Power Query

The date dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the point of view of the passage of time.

Power Query vs. Power BI Rest API
Štěpán Rešl
m power_query rest_api admin azure

Power Query vs. Power BI Rest API

The Power BI Service hides data that is not visible at first peek but can help us control the Service and properly check whether there are any irregularities. It may sound a bit recursive, but let's get this data into Power BI using Power Query so we can start creating reports from it. Why to leave your favorite tool when there is no need for that at all.

Markdown

markdown

1 Posts
Lessons learnt from PySpark Notebooks and extracting APIs
Štěpán Rešl
fabric notebook pyspark markdown api

Lessons learnt from PySpark Notebooks and extracting APIs

PySpark Notebooks inside Fabric are a high-speed solution for data transformation. But what about their ability to get data from the API?

Measure

measure

1 Posts
Number of Measures Matters
Štěpán Rešl
dax development performance measure

Number of Measures Matters

Measures are a crucial component in Power BI. But can we have an unlimited number of them?

Monitoring

monitoring

2 Posts
Domains
Štěpán Rešl
admin api rest_api service monitoring domains

Domains

As your Power BI / Microsoft Fabric Service grows, the need arises for you to be able to divide the content in a little more detail (e.g., which division/department should have access to the given data)

Dataflows refresh monitoring
Štěpán Rešl
power_automate api dataflow admin monitoring

Dataflows refresh monitoring

Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.

Notebook

notebook

2 Posts
Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists
Štěpán Rešl
fabric sharepoint dataflow copy_activity notebook api

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists

Excel is not a database... so Sharepoint is not a database. But that doesn't mean that people don't use it that way often, and even if they don't, we need to get the data out of them to use it.

Lessons learnt from PySpark Notebooks and extracting APIs
Štěpán Rešl
fabric notebook pyspark markdown api

Lessons learnt from PySpark Notebooks and extracting APIs

PySpark Notebooks inside Fabric are a high-speed solution for data transformation. But what about their ability to get data from the API?

Notebooks

notebooks

3 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Write your data into Lakehouse by Notebooks
Štěpán Rešl
fabric python development notebooks pyspark

Write your data into Lakehouse by Notebooks

There are many ways to write data into Lakehouse, even using Notebooks.

Orchestration Fabric Notebooks
Štěpán Rešl
fabric orchestration development notebooks pyspark

Orchestration Fabric Notebooks

How to manage individual notebooks to efficiently utilize shared environment resources?

Offset

offset

1 Posts
OFFSET and its usage with Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting offset

OFFSET and its usage with Calculation Groups

December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation with Calculation Groups.

Orchestration

orchestration

1 Posts
Orchestration Fabric Notebooks
Štěpán Rešl
fabric orchestration development notebooks pyspark

Orchestration Fabric Notebooks

How to manage individual notebooks to efficiently utilize shared environment resources?

Performance

performance

1 Posts
Number of Measures Matters
Štěpán Rešl
dax development performance measure

Number of Measures Matters

Measures are a crucial component in Power BI. But can we have an unlimited number of them?

Power_automate

power_automate

3 Posts
Execute Query endpoint - Get your data from datasets
Štěpán Rešl
dax api rest_api power_automate development data_extraction

Execute Query endpoint - Get your data from datasets

The fact that I have data in Power BI does not end the story. This is the start of a new one!

Dataflows refresh monitoring
Štěpán Rešl
power_automate api dataflow admin monitoring

Dataflows refresh monitoring

Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.

Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?
Štěpán Rešl
power_automate rest_api service data_driven

Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?

At the end of last year, one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API. It is an endpoint that allows you to extract data directly from datasets.

Power_query

power_query

7 Posts
Power BI Templates
Štěpán Rešl
template development power_query governance service

Power BI Templates

".pbit" files are well-known in the Power BI world. But this is not the only type of "template" we can encounter. It depends on the scenario we are trying to fulfill.

Extraction of Colored Excel Cells
Štěpán Rešl
m power_query extraction excel

Extraction of Colored Excel Cells

Everyone knows that Power Query can get data from individual cells in Excel. But what about only colored cells?

Parsing data from JSONs
Štěpán Rešl
m power_query development json record list

Parsing data from JSONs

JSON is one of the most common data file types you'll get back when you try downloading data from an API.

Documentation options in Power Query
Štěpán Rešl
m power_query documentation comments development

Documentation options in Power Query

Document your code! One day you will thank yourself, or someone else will thank you, who will take over.

APIs as Power BI Datasources
Štěpán Rešl
m power_query api

APIs as Power BI Datasources

There is an abundance of APIs around us, and we use them in our daily routine without thinking about them anymore.

Date dimensions in Power Query
Štěpán Rešl
m power_query date dimension

Date dimensions in Power Query

The date dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the point of view of the passage of time.

Power Query vs. Power BI Rest API
Štěpán Rešl
m power_query rest_api admin azure

Power Query vs. Power BI Rest API

The Power BI Service hides data that is not visible at first peek but can help us control the Service and properly check whether there are any irregularities. It may sound a bit recursive, but let's get this data into Power BI using Power Query so we can start creating reports from it. Why to leave your favorite tool when there is no need for that at all.

Powershell

powershell

1 Posts
Rebinding Power BI Reports to Different Dataset
Štěpán Rešl
admin service rest_api powershell

Rebinding Power BI Reports to Different Dataset

Duplicate Power BI Dataset, from which colleagues have already managed to make their reports? Doesn't that sound scary? Personally yes!

Pyspark

pyspark

3 Posts
Write your data into Lakehouse by Notebooks
Štěpán Rešl
fabric python development notebooks pyspark

Write your data into Lakehouse by Notebooks

There are many ways to write data into Lakehouse, even using Notebooks.

Orchestration Fabric Notebooks
Štěpán Rešl
fabric orchestration development notebooks pyspark

Orchestration Fabric Notebooks

How to manage individual notebooks to efficiently utilize shared environment resources?

Lessons learnt from PySpark Notebooks and extracting APIs
Štěpán Rešl
fabric notebook pyspark markdown api

Lessons learnt from PySpark Notebooks and extracting APIs

PySpark Notebooks inside Fabric are a high-speed solution for data transformation. But what about their ability to get data from the API?

Python

python

2 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Write your data into Lakehouse by Notebooks
Štěpán Rešl
fabric python development notebooks pyspark

Write your data into Lakehouse by Notebooks

There are many ways to write data into Lakehouse, even using Notebooks.

Rankx

rankx

1 Posts
The dynamic ratio of top X products to the rest
Štěpán Rešl
dax rankx topn visual

The dynamic ratio of top X products to the rest

It would be best to give users different data exploration options when creating analytical views. This is one of the practical options.

Record

record

1 Posts
Parsing data from JSONs
Štěpán Rešl
m power_query development json record list

Parsing data from JSONs

JSON is one of the most common data file types you'll get back when you try downloading data from an API.

Rest_api

rest_api

5 Posts
Domains
Štěpán Rešl
admin api rest_api service monitoring domains

Domains

As your Power BI / Microsoft Fabric Service grows, the need arises for you to be able to divide the content in a little more detail (e.g., which division/department should have access to the given data)

Execute Query endpoint - Get your data from datasets
Štěpán Rešl
dax api rest_api power_automate development data_extraction

Execute Query endpoint - Get your data from datasets

The fact that I have data in Power BI does not end the story. This is the start of a new one!

Power Query vs. Power BI Rest API
Štěpán Rešl
m power_query rest_api admin azure

Power Query vs. Power BI Rest API

The Power BI Service hides data that is not visible at first peek but can help us control the Service and properly check whether there are any irregularities. It may sound a bit recursive, but let's get this data into Power BI using Power Query so we can start creating reports from it. Why to leave your favorite tool when there is no need for that at all.

Rebinding Power BI Reports to Different Dataset
Štěpán Rešl
admin service rest_api powershell

Rebinding Power BI Reports to Different Dataset

Duplicate Power BI Dataset, from which colleagues have already managed to make their reports? Doesn't that sound scary? Personally yes!

Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?
Štěpán Rešl
power_automate rest_api service data_driven

Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?

At the end of last year, one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API. It is an endpoint that allows you to extract data directly from datasets.

Rownumber

rownumber

1 Posts
Combining Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting rownumber data_storytelling visual

Combining Calculation Groups

Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.

Service

service

6 Posts
Power BI Templates
Štěpán Rešl
template development power_query governance service

Power BI Templates

".pbit" files are well-known in the Power BI world. But this is not the only type of "template" we can encounter. It depends on the scenario we are trying to fulfill.

Personal Workspaces in Times of Fabric
Štěpán Rešl
admin api service governance fabric

Personal Workspaces in Times of Fabric

From time to time, there is a need to talk about the possibilities, benefits, and dark sides that personal workspaces, aka "My workspace," bring.

Domains
Štěpán Rešl
admin api rest_api service monitoring domains

Domains

As your Power BI / Microsoft Fabric Service grows, the need arises for you to be able to divide the content in a little more detail (e.g., which division/department should have access to the given data)

Restrict Power BI Integration Button in Microsoft Lists
Štěpán Rešl
integration service admin sharepoint

Restrict Power BI Integration Button in Microsoft Lists

Power BI and integration to Sharepoint Lists have been with us for some time. Some can turn them on, or only specific groups of users can access them. But what to do if we have an open company policy so that everyone can use it, but then we have a specific List for which we would instead not show the integration? A JSON schema definition will help us.

Rebinding Power BI Reports to Different Dataset
Štěpán Rešl
admin service rest_api powershell

Rebinding Power BI Reports to Different Dataset

Duplicate Power BI Dataset, from which colleagues have already managed to make their reports? Doesn't that sound scary? Personally yes!

Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?
Štěpán Rešl
power_automate rest_api service data_driven

Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?

At the end of last year, one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API. It is an endpoint that allows you to extract data directly from datasets.

Sharepoint

sharepoint

2 Posts
Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists
Štěpán Rešl
fabric sharepoint dataflow copy_activity notebook api

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists

Excel is not a database... so Sharepoint is not a database. But that doesn't mean that people don't use it that way often, and even if they don't, we need to get the data out of them to use it.

Restrict Power BI Integration Button in Microsoft Lists
Štěpán Rešl
integration service admin sharepoint

Restrict Power BI Integration Button in Microsoft Lists

Power BI and integration to Sharepoint Lists have been with us for some time. Some can turn them on, or only specific groups of users can access them. But what to do if we have an open company policy so that everyone can use it, but then we have a specific List for which we would instead not show the integration? A JSON schema definition will help us.

Svg

svg

1 Posts
SVG options in Matrix
Štěpán Rešl
dax visual svg data_storytelling

SVG options in Matrix

Dynamic design using SVG? Sure! Here we go.

Template

template

1 Posts
Power BI Templates
Štěpán Rešl
template development power_query governance service

Power BI Templates

".pbit" files are well-known in the Power BI world. But this is not the only type of "template" we can encounter. It depends on the scenario we are trying to fulfill.

Topn

topn

1 Posts
The dynamic ratio of top X products to the rest
Štěpán Rešl
dax rankx topn visual

The dynamic ratio of top X products to the rest

It would be best to give users different data exploration options when creating analytical views. This is one of the practical options.

Typescript

typescript

1 Posts
Fabric Notification Bot for Microsoft Teams
Štěpán Rešl
fabric azure python development notebooks api typescript data_storytelling data_extraction

Fabric Notification Bot for Microsoft Teams

Tired of missing key insights buried in Power BI alerts or overflowing email inboxes, I decided to build my own notification bot for Microsoft Teams. From frustration with Power Automate limitations to wiring up a custom Azure Web App and Bot that delivers beautifully structured Adaptive Cards straight into chats.

Visual

visual

3 Posts
Combining Calculation Groups
Štěpán Rešl
dax calculation_groups format_string conditional_formatting rownumber data_storytelling visual

Combining Calculation Groups

Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.

SVG options in Matrix
Štěpán Rešl
dax visual svg data_storytelling

SVG options in Matrix

Dynamic design using SVG? Sure! Here we go.

The dynamic ratio of top X products to the rest
Štěpán Rešl
dax rankx topn visual

The dynamic ratio of top X products to the rest

It would be best to give users different data exploration options when creating analytical views. This is one of the practical options.

Window

window

1 Posts
Dynamic windows in calculation groups
Štěpán Rešl
dax calculation_groups field_parameters window

Dynamic windows in calculation groups

The WINDOWS function is becoming very popular because it can save a lot of time both for the execution of the calculation and for the development itself. At the same time, this is the last of the new functions I need to test against Calculation Groups.

Štěpán Rešl

Štěpán Rešl

Don't say it cannot be done, or someone who doesn't know it will come and do it. In Power BI this works twice.

Written by Human not by AI

Follow

  • Twitter
  • Linkedin
  • Github
  • Mastodon
  • Rss

Suggestions

  • Home
  • DAX articles
  • Power BI Learning Point
  • Power BI Cheatsheets
  • PowerQuery.How
2025 © Data Meerkat. Powered by DataBrothers