BCS External Lists are Failing

%3CLINGO-SUB%20id%3D%22lingo-sub-1507495%22%20slang%3D%22en-US%22%3EBCS%20External%20Lists%20are%20Failing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507495%22%20slang%3D%22en-US%22%3E%3CP%3EBCS%20External%20Lists%20(connected%20to%20SQL%20Server%20VM%20on%20Azure)%20that%20had%20been%20working%20for%20more%20than%204%20years%20have%20just%20stopped%20working%20out%20of%20the%20blue.%26nbsp%3B%20I%20get%20the%20dreaded%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EUnable%20to%20display%20this%20Web%20Part.%26nbsp%3B%20...%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EWith%20a%20correlation%20ID.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1507495%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1507918%22%20slang%3D%22en-US%22%3ERe%3A%20BCS%20External%20Lists%20are%20Failing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1507918%22%20slang%3D%22en-US%22%3EOpen%20a%20support%20ticket...Microsoft%20has%20not%20done%20any%20work%20in%20BCS%20for%20years%20and%20I%20suspect%20they%20are%20doing%20%2F%20considering%20to%20do%20changes%20in%20the%20backend%20that%20might%20affect%20legacy%20services%20such%20as%20BCS.%20For%20instance%2C%20we%20learnt%20this%20week%20that%20SP%202010%20workflows%20in%20SPO%20are%20going%20to%20be%20deprecated%20starting%20next%20month%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1508586%22%20slang%3D%22en-US%22%3ERe%3A%20BCS%20External%20Lists%20are%20Failing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1508586%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20response%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%20and%20I%20agree%20with%20your%20suggestion%20that%20legacy%20features%20are%20getting%20pruned.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20trouble%20ticket%20was%20opened%20and%20here%20was%20the%20response%3A%3C%2FP%3E%3CP%3E%22To%20recap%2C%20to%20trouble%20shoot%20this%20issue%20SharePoint%20designers%20is%20needed%2C%26nbsp%3B%20However%20SharePoint%20Designer%20is%20not%20covered%20under%20MSFT%20365%20support.%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20guess%20is%20that%20some%20new%20rules%20are%20being%20enforced%20on%20exactly%20what%20SQL%20sources%20you%20can%20connect%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPer%20this%20article%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fintroduction-to-external-data-676e60e7-d99f-463f-a173-65e9d63538c0%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fintroduction-to-external-data-676e60e7-d99f-463f-a173-65e9d63538c0%3Fui%3Den-us%26amp%3Brs%3Den-us%26amp%3Bad%3Dus%3C%2FA%3E%3CBR%20%2F%3E%3CSTRONG%3E%3CEM%3E%22SPO%20only%20supports%20WCF%20and%20SQL%20Server%20Azure%20Connectors%22%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20appears%20that%20the%20SharePoint%20Online%20team%20just%20started%20enforcing%20this%20in%20the%20last%20few%20days%20(July%204th%20or%205th%2C%202020).%26nbsp%3B%20SQL%20Virtual%20Machines%20apparently%20did%20not%20make%20the%20cut.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Ben%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

BCS External Lists (connected to SQL Server VM on Azure) that had been working for more than 4 years have just stopped working out of the blue.  I get the dreaded:

Unable to display this Web Part.  ...

 

With a correlation ID.

3 Replies
Open a support ticket...Microsoft has not done any work in BCS for years and I suspect they are doing / considering to do changes in the backend that might affect legacy services such as BCS. For instance, we learnt this week that SP 2010 workflows in SPO are going to be deprecated starting next month

Thanks for the response @Juan Carlos González Martín and I agree with your suggestion that legacy features are getting pruned.

 

A trouble ticket was opened and here was the response:

"To recap, to trouble shoot this issue SharePoint designers is needed,  However SharePoint Designer is not covered under MSFT 365 support."

 

My guess is that some new rules are being enforced on exactly what SQL sources you can connect to.

 

Per this article 

https://support.microsoft.com/en-us/office/introduction-to-external-data-676e60e7-d99f-463f-a173-65e...
"SPO only supports WCF and SQL Server Azure Connectors"

 

It appears that the SharePoint Online team just started enforcing this in the last few days (July 4th or 5th, 2020).  SQL Virtual Machines apparently did not make the cut.

 

-Ben

@BandDad 

 

 

I have also been looking through the same documentation.  In my case I have been asked surface 

external lists hosted in classic SPO pages ( yes really!)  and with data residing on SQL Server 2016 on-premises, via the Azure Data Gateway.  I am trying to get my head around what can be achieved or indeed supported:sad:

 

  1.  External lists  without BCS, 
  2. External  lists using WCF, with BCS configured on SharePoint Online 
  3. Only available to users with E3 or E5 or SharePoint Plan 2 licenses
  4. Creating DataSources in 1) SharePoint Designer 2010 2) SharePoint 2013.  
  5. Just going with SQL Server Connectors via Power Apps designer - this does work yay!