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
Monthly Archives of September 2015
Filter SQL-server queries with Excel-tables: Query folding limitations and bug workaround
Power Query provides excellent functions to filter your SQL-Server queries by complete Excel-tables instead of just single parameters (like in all other Excel-based approaches). But you need to take care that (…) Read more
Excel Cubefunctions: Trick for dynamic sets
Today I read Andrew Todd’s brilliant guest post on Powerpivotpro.com about some really cool tricks on cubefunctions. The second one shows a very elegant solution to what I’ve formerly done (…) Read more