Forum Discussion

jimranish's avatar
jimranish
Copper Contributor
Jul 04, 2020

Unexpected error importing with Power Query

I have Microsoft 365 and have been trying to use Get & Transform for the first time. I tried importing from web pages (including the same URL as in a tutorial video), a text file and another workbook, closing and reopening the workbook each time.

 

All give the same message right away: Unexpected error. Something went wrong. If the problem continues, please restart Excel.

developer
excel
office 365

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 05, 2020

    jimranish 

    Before reinstalling the Office try to clean cache in Data->GetData->Query Options. In addition, be sure only one file with Power Query is opened.

    After that yes, try to repair Office and check Windows updates are installed properly (that could be an issue with .net framework which could cause such error).

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Jul 05, 2020

    Hi jimranish 

     

    May be you can try repairing the Office & It should work fine, also request you to please attached the screenshot of the error along with file

     

    below link for repair office 

    https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more

Resources