Unexpected error importing with Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1504413%22%20slang%3D%22en-US%22%3EUnexpected%20error%20importing%20with%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504413%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20Microsoft%20365%20and%20have%20been%20trying%20to%20use%20Get%20%26amp%3B%20Transform%20for%20the%20first%20time.%20I%20tried%20importing%20from%20web%20pages%20(including%20the%20same%20URL%20as%20in%20a%20tutorial%20video)%2C%20a%20text%20file%20and%20another%20workbook%2C%20closing%20and%20reopening%20the%20workbook%20each%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20give%20the%20same%20message%20right%20away%3A%26nbsp%3BUnexpected%20error.%20Something%20went%20wrong.%20If%20the%20problem%20continues%2C%20please%20restart%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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.

2 Replies
Highlighted

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-a6b4...

 

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

Highlighted

@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).