Sign in
 

none
Feature request -- populate PP table from DAX query returning a table

 , 
 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi. I wanted to do a CROSSJOIN, but while PowerPivot allows populating a columns using DAX formulas, CROSSJOIN returns a table. I wanna reuse the result table (so not storing in an intermediate table seems inefficient), but the result table exceeds 1M rows, meaning Excel sheets (and therefore 3rd-party plugin DAX Studio) are out too.

    After asking around elsewhere in vain, I got confirmation from Chris Webb that populating a PowerPivot table from a DAX query returning a table appears to be a missing feature at the moment, while current workarounds (using SSAS, or transpose in Excel -> Power Query unpivot -> load back to data model as I attempted) would negate a straight-forward refresh when new data is added.

    Is this a feature that could be expected from a future release?

    Thursday, October 31, 2013 2:01 AM
    |

Answers

All replies