top of page
Suche


Clean up your Power BI reports and semantic models with TMDL view and Measure Killer in 1 minute
This short video outlines to power of using TMDL view in Power BI Desktop combined with the latest version of Measure Killer to remove all u

Brunner_BI
21. Feb.1 Min. Lesezeit
146 Ansichten
0 Kommentare


Searching a Power BI report's M code with a few clicks
We show how you can easily search a Power BI semantic model's M code in just a few clicks using an external tool.

Brunner_BI
19. Aug. 20242 Min. Lesezeit
37 Ansichten
0 Kommentare


Integrating Jira with Power BI
In this blog post we can see how we can easily connect Power BI to the Jira REST API to retrieve data.

Brunner_BI
28. Juni 20242 Min. Lesezeit
183 Ansichten
0 Kommentare


Query folding and data types from Snowflake in Power BI
When working with decimals and integers from Snowflake in Power Query, you need to watch out for data type conversion.

Brunner_BI
21. Juni 20242 Min. Lesezeit
117 Ansichten
0 Kommentare


Removing unused columns and measures in Power BI
How to remove unused columns and measures using Power BI external tool Measure Killer

Brunner_BI
19. Nov. 20223 Min. Lesezeit
808 Ansichten
0 Kommentare


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

Brunner_BI
27. Juni 20221 Min. Lesezeit
1.266 Ansichten
0 Kommentare


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.
christian9596
24. Juni 20222 Min. Lesezeit
1.555 Ansichten
1 Kommentar


New ways to check if queries fold in Power Query
This article outlines an approach besides "View Native Query" to check if query folding is happening in Power BI / Power Query or not

Brunner_BI
29. Jan. 20221 Min. Lesezeit
1.694 Ansichten
0 Kommentare


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. This can be handy as well for a

Brunner_BI
30. Dez. 20212 Min. Lesezeit
205 Ansichten
1 Kommentar


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

Brunner_BI
15. Dez. 20211 Min. Lesezeit
509 Ansichten
0 Kommentare


How to avoid having to use a personal gateway for web data sources (html page or table) in Power BI
When you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...

Brunner_BI
29. Dez. 20201 Min. Lesezeit
3.595 Ansichten
8 Kommentare


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

Brunner_BI
17. Dez. 20201 Min. Lesezeit
2.295 Ansichten
0 Kommentare


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.

Brunner_BI
15. Dez. 20201 Min. Lesezeit
1.254 Ansichten
0 Kommentare
bottom of page