While the relationships view of the datamodel provides a very good overview which tables are connected to each other, one cannot see at a glance on which field they are (…) Read more
Posts in Category ‘Allgemein’
Dynamic Power Query X-mas tree in Excel
Wishing my faithful readers peaceful and happy holidays. Hope you enjoy my jumping Power Query X-mas tree: It changes his size or decoration randomly every time you press refresh: Totally auto-M-agically 😉 (No (…) Read more
Speed up the PowerBI and Power Query design process
When querying large databases with Power BI or Power Query, the design of the query itself sometimes causes long waiting periods because of background loading activities. In order to speed up (…) Read more
Happy Spreadsheet Day! (Or how to escape Excel-hell)
When reading horror-stories about Excel-hell describing how dangerous it is to use Excel in corporate environments, I cannot help but to think of this hilarious video describing the fatal consequences of acting without (…) Read more
Perfect Analysis Services (SSAS) reports in Excel using Power Query
Excel-reports on SSAS cubes (multidimensional and tabular) can have some flaws that now can be overcome by using Power Query for sourcing your cubedata: filter your cube by complete Excel-tables without loading them to the model/cube (…) Read more