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
Ed Hansberry's avatar
Ed Hansberry
Iron Contributor
Feb 11, 2019
Cfo-Bi_65 wrote:

Hi

 

Same problem. However, and strangely, seems to work fine in Power BI Desktop.

 

 

That button always launches Power Query in Power BI. There isn't an equivalent button in Power BI that corresponds to the "From Other Sources" button in Power Pivot for Excel that launches the table import wizard. 

 

Maybe they will modify that button to just launch Power Query in Excel. ¯\_(ツ)_/¯

RobinH's avatar
RobinH
Brass Contributor
Feb 15, 2019

Looks like it's acknowledged as a bug, and due to be fixed:

https://answers.microsoft.com/en-us/msoffice/forum/all/office-365-excel-version-1901-build-1123120130/fbac40b4-8e32-4862-8d23-61939d4b20dc

When 1902 will be released though...

  • Ed Hansberry's avatar
    Ed Hansberry
    Iron Contributor
    Feb 15, 2019

    Good news. I am sure 1902 will be in in the next few days. 1903 was released yesterday for the Insider track.

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

      I can confirm it works again in 1903 - I installed it today :-)

      • ginofranko82's avatar
        ginofranko82
        Copper Contributor
        Feb 15, 2019
        Hi Mike, can you please tell me how to install it? Thank you

Resources