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 division/department should have access to the given data)
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
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
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
Duplicate Power BI Dataset, from which colleagues have already managed to make their reports? Doesn't that sound scary? Personally yes!
api
7 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, we need to get the data out of them to use it.
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 division/department should have access to the given data)
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 the need to control them.
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
1 Posts
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
6 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 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
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 with Calculation Groups.
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
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
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
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 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
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
7 Posts
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 with Calculation Groups.
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
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
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
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
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
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, we need to get the data out of them to use it.
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 to extract data directly from datasets.
data_extraction
1 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!
data_storytelling
1 Posts
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, we need to get the data out of them to use it.
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
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 point of view of the passage of time.
dax
12 Posts
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 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
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 with Calculation Groups.
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
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
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
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
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
4 Posts
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 point of view of the passage of time.
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 division/department should have access to the given data)
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
3 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, we need to get the data out of them to use it.
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 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
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
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
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
4 Posts
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 with Calculation Groups.
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
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
1 Posts
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.
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 where the hierarchy does not continue to the same levels or that the "+/-" icon appears even when we don't want it to.
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 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
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.
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 point of view of the passage of time.
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
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?
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 division/department should have access to the given data)
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
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, we need to get the data out of them to use it.
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?
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 with Calculation Groups.
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 the need to control them.
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
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 point of view of the passage of time.
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
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
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?
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 division/department should have access to the given data)
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 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
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 to extract data directly from datasets.
service
5 Posts
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 division/department should have access to the given data)
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
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 to extract data directly from datasets.
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, we need to get the data out of them to use it.
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
1 Posts
SVG options in Matrix
Dynamic design using SVG? Sure! Here we go.
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.
visual
2 Posts
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 itself. At the same time, this is the last of the new functions I need to test against Calculation Groups.