Jul 04 2020 08:36 AM
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.
Jul 05 2020 04:55 AM
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
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
Jul 05 2020 06:54 AM
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).