Data Meerkat
  • Home
  • Templates
  • About

Recent content

Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists
30 Oct 2023

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

Personal Workspaces in Times of Fabric
15 Aug 2023

Personal Workspaces in Times of Fabric

Lessons learnt from PySpark Notebooks and extracting APIs
30 Jun 2023

Lessons learnt from PySpark Notebooks and extracting APIs

Extraction of Colored Excel Cells
13 Jun 2023

Extraction of Colored Excel Cells

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 hierarchies index integration json list m markdown measure monitoring notebook offset performance power_automate power_query powershell pyspark rankx record rest_api service sharepoint svg topn 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

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

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

1 Posts
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

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

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

7 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

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

1 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!

Data_storytelling

data_storytelling

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.

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

12 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?

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

4 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?

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

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

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

4 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

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

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

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?

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.

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

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.

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

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?

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.

Service

service

5 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)

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.

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.

Visual

visual

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

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.

Follow

  • Twitter
  • Linkedin
  • Github
  • Mastodon
  • Rss

Suggestions

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