Query is unsafe / external connection failed to refresh

%3CLINGO-SUB%20id%3D%22lingo-sub-109285%22%20slang%3D%22en-US%22%3EQuery%20is%20unsafe%20%2F%20external%20connection%20failed%20to%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109285%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Microsoft%20Teams%20to%20view%20an%20excel%20document%20I%20have%20made%20that%20contains%20queries.%20However%2C%20I%20am%20getting%20an%20error%20when%20refreshing%20the%20file%20from%20teams.%20I%20get%20the%20following%20errors%20when%20i%20go%20to%20refresh%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%3E%22Be%20careful.%20This%20workbook%20contains%20one%20or%20more%20queries%20that%20might%20be%20unsafe.%3C%2FDIV%3E%3CP%3E%26nbsp%3BDo%20you%20want%20to%20enable%20these%20queries%3F%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BWhen%20I%20select%20Yes%2C%20I%20then%20get%20this%20error%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%22We%20were%20unable%20to%20refresh%20one%20or%20more%20data%20connections%20in%20this%20workbook.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThe%20following%20connections%20failed%20to%20refresh%3A%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%3EQuery%20-%20All%22%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20when%20I%20open%20the%20document%2C%20my%20queries%20seem%20to%20work%20fine%3F%20Is%20this%20a%20problem%20with%20my%20queries%20or%20with%20microsoft%20teams%3F%20I%20have%20the%20queries%20gathering%20data%20in%20tables%20across%20various%20sheets%20in%20the%20workbook%2C%20then%20combines%20all%20of%20these%20tables%20into%20one%20master%20table%20in%20its%20own%20sheet.%20These%20queries%20auto%20refresh%20every%2010%20minutes%2C%20also%20refresh%20on%20file%20open.%20The%20workbook%20is%20also%20required%20to%20be%20checked%20out%20by%20the%20user%20for%20them%20to%20make%20edits%2C%20not%20sure%20if%20this%20could%20cause%20it%20not%20to%20refresh.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESome%20direction%20on%20how%20to%20fix%20this%20would%20be%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-109285%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-109609%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20is%20unsafe%20%2F%20external%20connection%20failed%20to%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-109609%22%20slang%3D%22en-US%22%3EIMHO%20the%20problems%20you%20are%20having%20are%20not%20related%20to%20Teams%2C%20but%20they%20are%20related%20to%20Excel%20Online...have%20you%20tried%20to%20open%20the%20file%20directly%20from%20the%20Team%20SPO%20Site...you%20should%20have%20the%20same%20problem%20so%20I%20guess%20what%20you%20are%20trying%20to%20do%20is%20not%20supported%20by%20Excel%20Online%20what%20implies%20you%20have%20to%20use%20the%20desktop%20client%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1025826%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20is%20unsafe%20%2F%20external%20connection%20failed%20to%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1025826%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F80153%22%20target%3D%22_blank%22%3E%40Matthew%20Cooley%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20wondering%20whether%20you%20were%20able%20to%20find%20a%20fix%20for%20this%20in%20the%20end%3F%20Having%20the%20same%20issue%20whilst%20hosting%20an%20Excel%20workbook%20via%20MS%20Teams.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoe%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1152865%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20is%20unsafe%20%2F%20external%20connection%20failed%20to%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1152865%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F80153%22%20target%3D%22_blank%22%3E%40Matthew%20Cooley%3C%2FA%3E%26nbsp%3Bfollowing%20this%20as%20I%20have%20the%20same%20issue.%20would%20be%20great%20to%20get%20a%20resolution%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1791919%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20is%20unsafe%20%2F%20external%20connection%20failed%20to%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1791919%22%20slang%3D%22en-US%22%3EI%20get%20the%20same%20issue.%20Anyone%20figure%20this%20out%3F%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi Guys,

 

I am using Microsoft Teams to view an excel document I have made that contains queries. However, I am getting an error when refreshing the file from teams. I get the following errors when i go to refresh:

 

"Be careful. This workbook contains one or more queries that might be unsafe.

 Do you want to enable these queries?"

 

 When I select Yes, I then get this error:

 

"We were unable to refresh one or more data connections in this workbook. 
The following connections failed to refresh: 


Query - All"

 

 

However, when I open the document, my queries seem to work fine? Is this a problem with my queries or with microsoft teams? I have the queries gathering data in tables across various sheets in the workbook, then combines all of these tables into one master table in its own sheet. These queries auto refresh every 10 minutes, also refresh on file open. The workbook is also required to be checked out by the user for them to make edits, not sure if this could cause it not to refresh.

 

Some direction on how to fix this would be appreciated!

4 Replies
Highlighted
IMHO the problems you are having are not related to Teams, but they are related to Excel Online...have you tried to open the file directly from the Team SPO Site...you should have the same problem so I guess what you are trying to do is not supported by Excel Online what implies you have to use the desktop client
Highlighted

Hi, @Matthew Cooley

 

Just wondering whether you were able to find a fix for this in the end? Having the same issue whilst hosting an Excel workbook via MS Teams.

 

Thanks,

 

Joe 

Highlighted

@Matthew Cooley following this as I have the same issue. would be great to get a resolution

Highlighted
I get the same issue. Anyone figure this out?