Blog | Brunner BI

Limitations of the Power BI lineage view or impact analysis

Aug 24, 20231 min read

Limitations of the Power BI lineage view or impact analysis

A major limitation of the Power BI lineage view or impact analysis is that even for tenant admins it does not provide a full picture.

258 views0 comments

Removing unused columns and measures in Power BI

Brunner_BI

Nov 19, 20223 min read

Removing unused columns and measures in Power BI

How to remove unused columns and measures using brand new Power BI external tool Measure Killer

2,999 views2 comments

Brunner_BI

Sep 21, 20221 min read

Measure Killer Feedback

In this blog post you can give feedback about the Power BI external tool Measure Killer published by Brunner BI.

4,528 views344 comments

Page limits for email subscriptions in Power BI Premium

christian9596

Jun 29, 20221 min read

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.

477 views0 comments

Finding errors in Dataflows or PowerQuery

Brunner_BI

Jun 27, 20221 min read

Finding errors in Dataflows or PowerQuery

This article outlines how you can find errors quickly in Dataflows or PowerQuery using a small M script.

2,877 views3 comments

How to open .ods files in Power BI / Power Query

christian9596

Jun 24, 20222 min read

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.

3,470 views0 comments

How to disable the automatic refresh of a dataset after upload to the Power BI Service

Brunner_BI

May 13, 20222 min read

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.

6,480 views0 comments

Format strings for calculation groups in live reports

Brunner_BI

Apr 13, 20222 min read

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.

967 views0 comments

Exporting data from Power BI Desktop without limits

Brunner_BI

Apr 5, 20221 min read

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.

8,353 views6 comments

New ways to check if queries fold in Power Query

Brunner_BI

Jan 29, 20221 min read

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

2,570 views4 comments

Allocating amounts using lists in Power Query

Brunner_BI

Dec 30, 20212 min read

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.

522 views0 comments

Extending calculation groups in Power BI with unstructured data (targets, budgets etc.)

Brunner_BI

Dec 18, 20212 min read

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

944 views0 comments

Dataflows gets around the 3,000 cell enter data limit in Power BI

Brunner_BI

Dec 14, 20211 min read

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

1,707 views0 comments

martin1119

Sep 30, 20212 min read

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.

1,250 views0 comments

How I use Azure VMs for Power BI development

Brunner_BI

Sep 4, 20217 min read

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

2,902 views0 comments

Brunner_BI

Jul 10, 20213 min read

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

3,091 views0 comments

Dynamic pop-up or warning images in Power BI

Brunner_BI

Jul 3, 20213 min read

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

5,280 views0 comments

Dynamic tooltip pages in Microsoft Power BI for measure columns

Brunner_BI

Jun 5, 20211 min read

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.

5,939 views2 comments

Trigger instant refreshs of Power BI Datasets with Power Automate

Brunner_BI

Apr 24, 20211 min read

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.

568 views0 comments

Creating a custom fiscal calendar in Power BI

Brunner_BI

Apr 9, 20211 min read

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.

7,025 views0 comments

LINKS

Contact us

SOCIAL