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
Cfo-Bi_65's avatar
Cfo-Bi_65
Copper Contributor
Feb 09, 2019

Hi

 

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

 

 

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 :-)

Resources