Answered by:
Feature request -- populate PP table from DAX query returning a table

-
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?
Question
Answers
-
You should make Feature Requests on Connect. Sometimes the product team members will comment on them.
Thanks!
Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!- Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, November 29, 2013 11:37 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, December 16, 2013 7:31 PM
All replies
-
how about using Linkback Tables of Office 2013?
http://www.sqlbi.com/articles/linkback-tables-in-powerpivot-for-excel-2013this 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!
-gerhard
- 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
-
-
You should make Feature Requests on Connect. Sometimes the product team members will comment on them.
Thanks!
Ed Price, Power BI & SQL Server Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!- Proposed as answer by Ed Price - MSFTMicrosoft employee, Owner Friday, November 29, 2013 11:37 PM
- Marked as answer by Ed Price - MSFTMicrosoft employee, Owner Monday, December 16, 2013 7:31 PM