I recently came across a behavior of the Table.ColumnsOfType() function that I want to share with you today. Since this post talks about ascribed types in M, I …
[Weiterlesen...] Infos zum Plugin Pitfalls with Table.ColumnsOfType
Technical Topics
While all the other posts on this blog are in German, the Technical Topics are my way to contribute to the international Power BI community. The intention is to help others with these great tools and to learn myself from getting your comments. Enjoy.
How to identify Measures not used in your pbix file
WARINING: Due to a broken DMV in Power BI Desktop, that I use for this solution, we cannot use this tool anymore, until until Microsoft fixes the issue. Sorry …
[Weiterlesen...] Infos zum Plugin How to identify Measures not used in your pbix file
Ascribed types in M: why to generally avoid them
I recently stumbled across the topic 'ascribed types' in M after a while and had a very informative conversation with the Power Query dev team about it. In this …
[Weiterlesen...] Infos zum Plugin Ascribed types in M: why to generally avoid them
Records in Power Query – how, when and why
The M language has so-called structured values, to which lists, records and tables belong. Each value type serves specific purposes and this post is intended to …
[Weiterlesen...] Infos zum Plugin Records in Power Query – how, when and why
Lists in Power Query – how, when and why
The M language has so-called structured values, to which lists, records and tables belong. Each value type serves specific purposes and this post is intended to …
[Weiterlesen...] Infos zum Plugin Lists in Power Query – how, when and why
Join types in Power Query – SEE how it works
"Merge queries is one way to combine queries (or even different tables within the same query) in Power Query/M. This topic has already been extensively written …
[Weiterlesen...] Infos zum Plugin Join types in Power Query – SEE how it works
Query time periods with CUBE formulas in Excel
If your Excel file contains an Excel data model, you have the possibility to query this data model using so-called CUBE formulas within the Excel cells. This …
[Weiterlesen...] Infos zum Plugin Query time periods with CUBE formulas in Excel
Pivot shows values that are not part of the excel data model
I recently tried to help a customer who contacted me by phone with the following words: Lars, in my pivot data appear which are not contained in my Excel data …
[Weiterlesen...] Infos zum Plugin Pivot shows values that are not part of the excel data model
Culture codes in M functions
At the time of writing (October '18) there are 35 functions in M that accept a parameter called culture. The functionality of this parameter is relatively easy …
[Weiterlesen...] Infos zum Plugin Culture codes in M functions
My personal Best of Power BI @ MS Ignite 2018
This is my personal Best of Twitter tweets regarding Power BI news from MS Ignite 2018. Thanks to all Ignite participants who shared their experiences with the …
[Weiterlesen...] Infos zum Plugin My personal Best of Power BI @ MS Ignite 2018