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
Posts Tagged ‘Excel’
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
Power Query Management Studio reloaded: Now supports MDX
Very happy to see that my Power Query Management Studio isn’t just perceived nerdy but useful as well 🙂 Thanks to Dusty for his nice review. So let’s push it a bit further (…) Read more
Want to filter a PivotTable based on an external range or list?
In order to pass a list of filter arguments to your pivot table instead of selecting them all manually you can do the following: 1) Pass your filter table and your (…) Read more
Use Timeline or Slicers to filter your Power Query import
A question in the Mr. Excel forum this morning reminded me that the technique I’ve blogged about here could also be used to do simpler things like using a timeline (…) Read more
Report Design with Power Query (1): Cascading Time Granularities
Cascading Time Granularities When the client is not happy with the pivot report layout options on cubes in Excel, my usual reaction is “OK no problem, then we’re going to (…) Read more