Forum Discussion

annahui's avatar
annahui
Copper Contributor
Jan 29, 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
MikeThomas67's avatar
MikeThomas67
Brass Contributor
Feb 05, 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 06, 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/

     

     

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

      I am experiencing the same issue The "From Other Sources" button stops working just today (2/7), but it still worked not two days ago (2/5). I can confirm that importing text/csv through PowerQuery is a valid workaround. I hope they will fix this soon.