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
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.
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
Intellisense for Power Query/ M – finally
With the current release of Power BI Desktop (September 2018), a feature is available that many Power Query fans have been waiting for for no less than 3 years: …
[Weiterlesen...] Infos zum Plugin Intellisense for Power Query/ M – finally
Power BI history: From Designer Preview to Desktop June 18
The thing about hard drives is that you save a lot of files and then you don't look at them for years. I stumbled across a file from January 2015 these days: An …
[Weiterlesen...] Infos zum Plugin Power BI history: From Designer Preview to Desktop June 18