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.
admin
6 Posts
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!
ai
1 Posts
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 ...
api
9 Posts
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.
azure
2 Posts
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...
calculation_groups
7 Posts
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...
claude
1 Posts
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 ...
color
1 Posts
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...
comments
1 Posts
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
8 Posts
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...
copy_activity
1 Posts
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, ...
data_driven
1 Posts
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_extraction
2 Posts
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!
data_storytelling
3 Posts
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.
dataflow
2 Posts
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...
date
1 Posts
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...
dax
13 Posts
Combining Calculation Groups
Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.
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...
development
10 Posts
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.
dimension
1 Posts
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...
documentation
1 Posts
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
1 Posts
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...
excel
1 Posts
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
1 Posts
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 Posts
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?
field_parameters
4 Posts
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...
format_string
5 Posts
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 ...
governance
2 Posts
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.
graphql
1 Posts
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
1 Posts
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 ...
index
1 Posts
INDEX as a friend for Conditional Format Strings
INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers
integration
1 Posts
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...
json
1 Posts
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.
knowledge_management
1 Posts
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 ...
list
1 Posts
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
6 Posts
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...
markdown
1 Posts
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?
mcp
1 Posts
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 ...
measure
1 Posts
Number of Measures Matters
Measures are a crucial component in Power BI. But can we have an unlimited number of them?
monitoring
2 Posts
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...
notebook
2 Posts
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?
notebooks
3 Posts
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?
obsidian
1 Posts
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 ...
offset
1 Posts
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...
orchestration
1 Posts
Orchestration Fabric Notebooks
How to manage individual notebooks to efficiently utilize shared environment resources?
performance
1 Posts
Number of Measures Matters
Measures are a crucial component in Power BI. But can we have an unlimited number of them?
power_automate
3 Posts
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 ...
power_query
7 Posts
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...
powershell
1 Posts
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
3 Posts
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?
python
2 Posts
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.
rankx
1 Posts
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
1 Posts
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
5 Posts
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 ...
rownumber
1 Posts
Combining Calculation Groups
Calculation Groups are a powerful feature in Power BI that allows you to create reusable calculations.
service
6 Posts
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 ...
sharepoint
2 Posts
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...
svg
1 Posts
SVG options in Matrix
Dynamic design using SVG? Sure! Here we go.
template
1 Posts
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...
topn
1 Posts
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
1 Posts
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...
visual
3 Posts
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.
window
1 Posts
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...