Forum Discussion

annahui's avatar
annahui
Copper Contributor
Jan 30, 2019

Power Pivot in Excel 2019 - From other Sources button wont work

Hi guys,   I have recently upgrade my Microsoft Office to version 2019. I have no idea why the "From other sources" button in the Data Model window jus wont work. I tried repairing it locally, repa...
excel
cctanaka's avatar
cctanaka
Copper Contributor
Feb 05, 2019

Hi,

 

I have faced the same problem with Excel 2016 Pro Plus. I have not updated Office neither Windows in these last days, except Microsoft Security Essentials.

cctanaka's avatar
cctanaka
Copper Contributor
Feb 05, 2019

I have got a "solution".

Import data using Power Query (Data > Get Data)

Load To Data Model and create only connection

Return to Power Pivot

 

 

  • Josh_McHenry's avatar
    Josh_McHenry
    Copper Contributor
    Apr 19, 2019
    This isn't working for me, because as soon as you use PowerQuery, the data model can no longer be converted to a SSAS Tabular Model. The idea here is we are prototyping in PowerPivot and converting to SSAS. Microsoft PLEASE FIX THIS.
    • Ed Hansberry's avatar
      Ed Hansberry
      Iron Contributor
      Apr 21, 2019

      Josh_McHenry  this was fixed months ago, back in mid-Feb 2019. If your version isn't working, make sure you have the latest available from Office 365. AFAIK, it was never broken on the perpetual licensing versions.

  • daniel1926's avatar
    daniel1926
    Copper Contributor
    Feb 24, 2019
    Interesting indeed but what if we don not want to load the data in a query ... only in the data model! Hummmm.
  • annahui's avatar
    annahui
    Copper Contributor
    Feb 07, 2019

    that's what i'm thinking of doing as well. "Add/Load to Data Model". 
    But I am an instructor, there are some modules that I have to cover importing data into the data model. 

  • MikeThomas67's avatar
    MikeThomas67
    Brass Contributor
    Feb 06, 2019

    That was my suggested solution too as I posted earlier in this thread. Seems to be the only way round it

    • elliotdavis's avatar
      elliotdavis
      Copper Contributor
      Feb 06, 2019

      I am a beginner to Power Pivot. I'm not really sure how your solution works. I have a few tabs of data in an Excel document. Without using the From Other Sources button, how would I get these into Power Pivot?

      • annahui's avatar
        annahui
        Copper Contributor
        Feb 07, 2019

        You can try using Power Query to Merge or Append all these data. Upon "Close and Load", select "Add to Data Model"

        check out this link:

        https://support.office.com/en-us/article/Add-a-query-to-an-Excel-worksheet-Power-Query-ca69e0f0-3db1-4493-900c-6279bef08df4

         

        To combine data from multiple sheets:

        https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/

         

         

Resources