Combining Calculation Groups
Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.
DAX
13 articles
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
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
Dynamic design using SVG? Sure! Here we go.
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
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 i...
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
December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation...
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 s...
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 ...
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 ...
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 ...
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 fin...
Calculation groups
7 articles
Combining Calculation Groups
Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.
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 i...
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
December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation...
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 s...
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 ...
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 fin...
Field parameters
4 articles
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 i...
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 ...
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 ...
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 fin...
Conditional formatting
8 articles
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
INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers
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...
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 s...
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 ...
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 ...
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 ...
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 fin...
Power Automate
3 articles
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
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 th...
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 ...
REST API
5 articles
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 di...
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
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 irre...
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?
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 ...
Service
6 articles
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...
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
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 di...
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 th...
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?
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 ...
Data driven
1 article
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 ...
Admin
6 articles
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
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 di...
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 th...
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 th...
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 irre...
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!
PowerShell
1 article
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!
Hierarchies
1 article
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 ...
Format string
5 articles
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
INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers
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...
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 ...
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 ...
Color
1 article
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 s...
M
6 articles
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
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
Document your code! One day you will thank yourself, or someone else will thank you, who will take over.
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
The date dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the p...
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 irre...
Power Query
7 articles
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...
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
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
Document your code! One day you will thank yourself, or someone else will thank you, who will take over.
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
The date dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the p...
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 irre...
Azure
2 articles
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 Team...
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 irre...
Integration
1 article
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 th...
SharePoint
2 articles
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, ...
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 th...
OFFSET
1 article
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...
INDEX
1 article
INDEX as a friend for Conditional Format Strings
INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers
WINDOW
1 article
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 i...
Date
1 article
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 p...
Dimension
1 article
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 p...
API
9 articles
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 Team...
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
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, ...
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
PySpark Notebooks inside Fabric are a high-speed solution for data transformation. But what about their ability to get data from the API?
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 di...
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
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 th...
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.
Dataflow
2 articles
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, ...
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 th...
Monitoring
2 articles
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 di...
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 th...
Documentation
1 article
Documentation options in Power Query
Document your code! One day you will thank yourself, or someone else will thank you, who will take over.
Comments
1 article
Documentation options in Power Query
Document your code! One day you will thank yourself, or someone else will thank you, who will take over.
Development
10 articles
I built my "AI Brain" in Obsidian. Then I had to tear it down.
Everyone recommends Obsidian as THE solution for your "AI brain". I built one, and a few weeks later I had found four flaws that broke it. Here is ...
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 Team...
Write your data into Lakehouse by Notebooks
There are many ways to write data into Lakehouse, even using Notebooks.
Orchestration Fabric Notebooks
How to manage individual notebooks to efficiently utilize shared environment resources?
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
".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...
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
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
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
Document your code! One day you will thank yourself, or someone else will thank you, who will take over.
RANKX
1 article
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.
TOPN
1 article
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.
Visual
3 articles
Combining Calculation Groups
Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.
SVG options in Matrix
Dynamic design using SVG? Sure! Here we go.
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.
SVG
1 article
SVG options in Matrix
Dynamic design using SVG? Sure! Here we go.
Data storytelling
3 articles
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 Team...
Combining Calculation Groups
Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.
SVG options in Matrix
Dynamic design using SVG? Sure! Here we go.
Data extraction
2 articles
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 Team...
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!
JSON
1 article
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.
Record
1 article
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
1 article
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.
Performance
2 articles
I built six ways to let AI read my Obsidian vault. Then I checked which ones were lying
Writing into a vault is the easy part. Reading it out is where the money goes. Six read channels I actually shipped, what each of them costs, and t...
Number of Measures Matters
Measures are a crucial component in Power BI. But can we have an unlimited number of them?
Measure
1 article
Number of Measures Matters
Measures are a crucial component in Power BI. But can we have an unlimited number of them?
Domains
1 article
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 di...
Extraction
1 article
Extraction of Colored Excel Cells
Everyone knows that Power Query can get data from individual cells in Excel. But what about only colored cells?
Excel
1 article
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
7 articles
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 Team...
Write your data into Lakehouse by Notebooks
There are many ways to write data into Lakehouse, even using Notebooks.
Orchestration Fabric Notebooks
How to manage individual notebooks to efficiently utilize shared environment resources?
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
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, ...
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
PySpark Notebooks inside Fabric are a high-speed solution for data transformation. But what about their ability to get data from the API?
Notebook
2 articles
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, ...
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?
PySpark
3 articles
Write your data into Lakehouse by Notebooks
There are many ways to write data into Lakehouse, even using Notebooks.
Orchestration Fabric Notebooks
How to manage individual notebooks to efficiently utilize shared environment resources?
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?
Markdown
1 article
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?
Governance
2 articles
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...
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.
Copy activity
1 article
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, ...
Template
1 article
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...
ROWNUMBER
1 article
Combining Calculation Groups
Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.
GraphQL
1 article
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.
Orchestration
1 article
Orchestration Fabric Notebooks
How to manage individual notebooks to efficiently utilize shared environment resources?
Notebooks
3 articles
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 Team...
Write your data into Lakehouse by Notebooks
There are many ways to write data into Lakehouse, even using Notebooks.
Orchestration Fabric Notebooks
How to manage individual notebooks to efficiently utilize shared environment resources?
Python
2 articles
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 Team...
Write your data into Lakehouse by Notebooks
There are many ways to write data into Lakehouse, even using Notebooks.
TypeScript
1 article
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 Team...
AI
2 articles
I built six ways to let AI read my Obsidian vault. Then I checked which ones were lying
Writing into a vault is the easy part. Reading it out is where the money goes. Six read channels I actually shipped, what each of them costs, and t...
I built my "AI Brain" in Obsidian. Then I had to tear it down.
Everyone recommends Obsidian as THE solution for your "AI brain". I built one, and a few weeks later I had found four flaws that broke it. Here is ...
Obsidian
2 articles
I built six ways to let AI read my Obsidian vault. Then I checked which ones were lying
Writing into a vault is the easy part. Reading it out is where the money goes. Six read channels I actually shipped, what each of them costs, and t...
I built my "AI Brain" in Obsidian. Then I had to tear it down.
Everyone recommends Obsidian as THE solution for your "AI brain". I built one, and a few weeks later I had found four flaws that broke it. Here is ...
Claude
2 articles
I built six ways to let AI read my Obsidian vault. Then I checked which ones were lying
Writing into a vault is the easy part. Reading it out is where the money goes. Six read channels I actually shipped, what each of them costs, and t...
I built my "AI Brain" in Obsidian. Then I had to tear it down.
Everyone recommends Obsidian as THE solution for your "AI brain". I built one, and a few weeks later I had found four flaws that broke it. Here is ...
MCP
2 articles
I built six ways to let AI read my Obsidian vault. Then I checked which ones were lying
Writing into a vault is the easy part. Reading it out is where the money goes. Six read channels I actually shipped, what each of them costs, and t...
I built my "AI Brain" in Obsidian. Then I had to tear it down.
Everyone recommends Obsidian as THE solution for your "AI brain". I built one, and a few weeks later I had found four flaws that broke it. Here is ...
Knowledge management
2 articles
I built six ways to let AI read my Obsidian vault. Then I checked which ones were lying
Writing into a vault is the easy part. Reading it out is where the money goes. Six read channels I actually shipped, what each of them costs, and t...
I built my "AI Brain" in Obsidian. Then I had to tear it down.
Everyone recommends Obsidian as THE solution for your "AI brain". I built one, and a few weeks later I had found four flaws that broke it. Here is ...
