Removing unused columns and measures in Power BI
How to remove unused columns and measures using brand new Power BI external tool Measure Killer
Search
Brunner_BI
- Sep 21
- 1 min
Measure Killer Feedback
In this blog post you can give feedback about the Power BI external tool Measure Killer published by Brunner BI.
300 views26 comments
christian9596
- Jun 29
- 1 min
Page limits for email subscriptions in Power BI Premium
In this blog post we outline specifics about the 20 page limit for Power BI email subscriptions in a Premium workspace.
69 views0 comments
Brunner_BI
- Jun 27
- 1 min
Finding errors in Dataflows or PowerQuery
This article outlines how you can find errors quickly in Dataflows or PowerQuery using a small M script.
225 views0 comments
christian9596
- Jun 24
- 2 min
How to open .ods files in Power BI / Power Query
This blog post shows how to import .ods files on the web natively into Power Query / Power BI.
577 views0 comments
Brunner_BI
- May 13
- 2 min
How to disable the automatic refresh of a dataset after upload to the Power BI Service
This blog post illustrates how to disable the automatic refresh in the Power BI service when uploading a dataset.
1,419 views0 comments
Brunner_BI
- Apr 13
- 2 min
Format strings for calculation groups in live reports
When building a live report on a dataset with a calculation group, format strings might not work as expected. We found a solution for this.
96 views0 comments
Brunner_BI
- Apr 5
- 1 min
Exporting data from Power BI Desktop without limits
If you want to export more than 30k or 150k rows, this blog post will help you get around the internal limits in Power BI.
1,150 views0 comments
Brunner_BI
- Jan 29
- 1 min
New ways to check if queries fold in Power Query
First of all we need to give some context to our title. Most of you will know that if "View Native Query" is greyed out in our...
520 views3 comments
Brunner_BI
- Dec 30, 2021
- 2 min
Allocating amounts using lists in Power Query
We will show you how to create dates between a start and an end date using the list operator in Power Query.
108 views0 comments
Brunner_BI
- Dec 18, 2021
- 2 min
Extending calculation groups in Power BI with unstructured data (targets, budgets etc.)
Calculation groups in Power BI a lot of times rely on time intelligence calculations. If you do not know calculation groups yet, read...
303 views0 comments
Brunner_BI
- Dec 14, 2021
- 1 min
Dataflows gets around the 3,000 cell enter data limit in Power BI
This blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop
597 views0 comments
martin1119
- Sep 30, 2021
- 2 min
Time saving scripts in Tabular Editor
How to format all dax measures in one click. How to add descriptions to your measures using Tabular Editor. Good for live reports e.g.
284 views0 comments
Brunner_BI
- Sep 4, 2021
- 7 min
How I use Azure VMs for Power BI development
For once this is not a technical blog about a feature or trick in Microsoft Power BI. In this blog post, I want to explain the benefits...
1,038 views0 comments
Brunner_BI
- Jul 10, 2021
- 3 min
How to visualize any map in Power BI
Until a few months ago, I have only worked with either Bing maps, filled maps or shape maps (these are the standard visuals in Power BI)....
900 views0 comments
Brunner_BI
- Jul 3, 2021
- 3 min
Dynamic pop-up or warning images in Power BI
For me, Power BI has become a rather complete tool over the last few years. Some things are still missing though, like pop-up messages....
1,388 views0 comments
Brunner_BI
- Jun 5, 2021
- 1 min
Dynamic tooltip pages in Microsoft Power BI for measure columns
This post explains how you can make your tooltip pages in MS Power BI completely dynamic to show different measures.
2,354 views0 comments
Brunner_BI
- Apr 24, 2021
- 1 min
Trigger instant refreshs of Power BI Datasets with Power Automate
Automatically trigger a refresh for a Power BI Dataset when a Dataflow refresh completes. This can be achieved easily using PowerApps.
336 views0 comments
Brunner_BI
- Apr 9, 2021
- 1 min
Creating a custom fiscal calendar in Power BI
Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.
1,887 views0 comments
Brunner_BI
- Apr 9, 2021
- 1 min
Changing data types that do not break query-folding in Power Query / Power BI
There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source
2,036 views3 comments