none
Power Query 2010 missing "load to data model" RRS feed

  • Question

  • A forum user here raised this issue.  http://powerpivotforum.com.au/viewtopic.php?f=5&t=101&p=439#p439

    the current build of Power Query for 2010 PowerQuery_2.18.3874.242 (64-bit) [en-us].msi

    seems to be missing the "load to data model" option.  I assume this is deliberate - can't imagine it was a mistake.  Why has this happened?  When will it be back?


    Matt

    Tuesday, February 17, 2015 9:23 PM

Answers

All replies

  • Hi Matt,

    In Excel 2010 you cannot load directly to the Data Model using Power Query Add-in. You can load the data to worksheet or connection only, and then use Power Pivot to load it to the Data Model. This is why you don't see the Load to Data Model option.

    See also this post.


    Wednesday, February 18, 2015 1:34 AM
  • Thanks for the quick reply.  Has this always been the case?  I am using 2013 so I don't know if I just imagined it being there in the past or if something has changed.  Either way, at least I know - thanks
    Wednesday, February 18, 2015 1:40 AM
  • Imagination is a good thing :)

    AFAIK it was always working this way in Excel 2010.

    Wednesday, February 18, 2015 1:57 AM