Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-1766156%22%20slang%3D%22en-US%22%3EPower%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766156%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Evening%2C%3C%2FP%3E%3CP%3ETo%20anyone%20out%20there%20familiar%20with%20Power%20Query%20in%20Office%20365%20Excel%2C%20I%20need%20some%20help%20getting%20it%20going.%3C%2FP%3E%3CP%3EThe%20problem%20I'm%20encountering%2C%20is%20when%20I%20am%20going%20through%20the%20tutorial%20and%20following%20the%20steps%20until%20I%20get%20to%20the%20bottom%20tab%20that%20indicates%20to%20Import%20Data%20from%20Web.%20When%20I%20get%20to%20click%20Ctrl%20V%2C%20I%20get%20an%20error%20message%20window%20saying%2C%20%22Unexpected%20Error%2C%22%20Something%20went%20wrong.%20If%20the%20problem%20continues%2C%20please%20restart%20Excel.%22%20Well%2C%20the%20problem%20is%20continuing%2C%20because%20that%20appears%20to%20be%20the%20problem%20that%20won't%20let%20me%20try%20anything%20else%20other%20than%20%22Copy%20detail%22%2C%20or%20%22Send%20a%20frown%22.%3C%2FP%3E%3CP%3ECan%20someone%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1766156%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766177%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766177%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F826939%22%20target%3D%22_blank%22%3E%40ricgarcia67%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20interesting.%20Could%20you%20please%20to%20give%20bit%20more%20details%20-%20what%20do%20you%20paste%20on%20which%20step%20and%20into%20which%20field.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766385%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20link%20is%20directly%20copied%20from%20%22Import%20data%20from%20web%22%20tab%20below%20on%20the%20tutorial%20as%20instructed.%20And%20tried%20to%20paste%2C%20but%20nothing%20happens%20except%20the%20error%20window%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766390%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F827015%22%20target%3D%22_blank%22%3E%40ricgarcia67660%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20but%20I%20have%20no%20idea%20about%20which%20tutorial%20do%20we%20speak%20about.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766393%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766393%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22lia-spoiler-container%22%3E%3CA%20class%3D%22lia-spoiler-link%22%20href%3D%22%23%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%20target%3D%22_blank%22%3ESpoiler%3C%2FA%3E%3CNOSCRIPT%3E(Highlight%20to%20read)%3C%2FNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-border%22%3E%3CDIV%20class%3D%22lia-spoiler-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3CNOSCRIPT%3E%3CDIV%20class%3D%22lia-spoiler-noscript-container%22%3E%3CDIV%20class%3D%22lia-spoiler-noscript-content%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FNOSCRIPT%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20the%20Excel%20office%20365%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766394%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20It's%20under%20the%20suggested%20searches%20in%20the%20tutorials%20that%20are%20in%20the%20New%20menu%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1766627%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1766627%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20at%20the%20point%20where%20even%20getting%20to%20open%20the%20power%20query%20on%20the%20Excel%2C%20brings%20up%20the%20%22Unexpected%20Error%22%2C%20message.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Good Evening,

To anyone out there familiar with Power Query in Office 365 Excel, I need some help getting it going.

The problem I'm encountering, is when I am going through the tutorial and following the steps until I get to the bottom tab that indicates to Import Data from Web. When I get to click Ctrl V, I get an error message window saying, "Unexpected Error," Something went wrong. If the problem continues, please restart Excel." Well, the problem is continuing, because that appears to be the problem that won't let me try anything else other than "Copy detail", or "Send a frown".

Can someone help?

12 Replies
Highlighted

@ricgarcia67 

That's interesting. Could you please to give bit more details - what do you paste on which step and into which field.

Highlighted

@Sergei Baklan 

 

The link is directly copied from "Import data from web" tab below on the tutorial as instructed. And tried to paste, but nothing happens except the error window

 

Highlighted

@ricgarcia67660 

Sorry, but I have no idea about which tutorial do we speak about.

Highlighted
Spoiler
 

@Sergei Baklan 

It's the Excel office 365

Highlighted

@Sergei Baklan 

      It's under the suggested searches in the tutorials that are in the New menu

 

Highlighted

@ricgarcia67660 

That's tons of suggested tutorials which are changed from to time in Suggested area. I guess this one

image.png

Sheet 14 says these sheets will be needed when you work with videos

image.png

In the same sheet there is the link on videos

image.png

If you open this web page and start with this video

image.png

it instructs you to copy the link you mentioned and what to do with it after that.

Highlighted

@Sergei Baklan 

It's at the point where even getting to open the power query on the Excel, brings up the "Unexpected Error", message.

Highlighted

@ricgarcia67660 

If you follow all tutorial instructions literally it shall be no such errors. On which exactly version of Excel and Power Query you are and on which exactly step such error appeared? I'll try to reproduce if you give more details, better with screenshots. 

Highlighted

@Sergei Baklan 

I appreciate your help. This is a new computer in which I am using Office 365. I haven't even the clue where my screen images are when I try to take a screen shot of the error message.

The error comes when I click File, then New, then Get to know Power Query.

Then when it tries to open, the error pops up and can't continue any more.

Highlighted

@Sergei Baklan 

 

I'm trying, as much as possible to follow the steps, but the error keeps coming up. I am not trying to skip any steps since this is new to me and I want to make sure I learn how to do this properly and efficiently. I don't even know who or if there is anyone in Microsoft tech to contact to ask them the question as to why this is happening.

 

Highlighted

@ricgarcia67660 

Without knowing of what exactly you are doing it's hard to help. Screenshot it's easy to generate, simplest way click Win+Shift+S to take it and copy to the clipboard, answering on post select Image icon

image.png

here click at any place in grey zone and Ctrl+V. Done after you see it.

 

Microsoft support - you may open the ticket if you pay for the support, otherwise this forum or answers.microsoft.com.

Highlighted