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. 

Resources