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?
how about using Linkback Tables of Office 2013?
this feature actually allows you to execute a DAX EVALUATE-command and return the results to an Excel table which can again be imported into PowerPivot
though, you still need to store the intermediate result in an Excel table
I agree that having this feature natively integrated into PowerPivot (and Tabular Models!) would be great!
- www.pmOne.com -
- Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, November 01, 2013 5:08 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, November 18, 2013 3:54 AM
- Unmarked as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, November 18, 2013 3:54 AM
- Unproposed as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, November 18, 2013 3:54 AM