Power Query from Web - Configuration Error Exception - Unable to retrieve configuration section "system.web/httpRuntime".

Question

I used Excel to build a Fantasy Football live scoreboard. For a few years it allowed me to scrape data from external sources. This year it's creating more of a headache over anything else.

I've been searching for similar issues online but it almost seems like my question isn't accurate. Below is a copy of the exception text & both online data sources. I can almost guarantee its not the website. It almost seems like my PC has a Framework error or the Add-In is broken.

Websites:

https://www.cbssports.com/nfl/stats/leaders/live/super-flex/1/

https://www.rotoballer.com/nfl-game-center-live-scores-fantasy-football-scoreboard

Exception Data:

************** Exception Text **************

Microsoft.Mashup.Host.Document.JavaScriptException: Unable to retrieve configuration section 'system.web/httpRuntime'. ---> System.Configuration.ConfigurationErrorsException: Unable to retrieve configuration section 'system.web/httpRuntime'.

at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)

at System.Web.Configuration.RuntimeConfig.get_HttpRuntime()

at System.Web.Util.HttpEncoder.GetCustomEncoderFromConfig()

at System.Lazy`1.CreateValue()

--- End of stack trace from previous location where exception was thrown ---

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

at System.Lazy`1.get_Value()

at System.Web.Util.HttpEncoder.get_Current()

at System.Web.Script.Serialization.JavaScriptSerializer.SerializeString(String input, StringBuilder sb)

at System.Web.Script.Serialization.JavaScriptSerializer.SerializeCustomObject(Object o, StringBuilder sb, Int32 depth, Hashtable objectsInUse, SerializationFormat serializationFormat)

at System.Web.Script.Serialization.JavaScriptSerializer.SerializeValueInternal(Object o, StringBuilder sb, Int32 depth, Hashtable objectsInUse, SerializationFormat serializationFormat, MemberInfo currentMember)

at System.Web.Script.Serialization.JavaScriptSerializer.SerializeValue(Object o, StringBuilder sb, Int32 depth, Hashtable objectsInUse, SerializationFormat serializationFormat, MemberInfo currentMember)

at System.Web.Script.Serialization.JavaScriptSerializer.Serialize(Object obj, StringBuilder output, SerializationFormat serializationFormat)

at System.Web.Script.Serialization.JavaScriptSerializer.Serialize(Object obj, SerializationFormat serializationFormat)

at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.OnGetInjectedElements()

--- End of inner exception stack trace ---

at DynamicLoader.getElementsToInject (ms-pq://pq.microsoft.com/ts/Shared/DynamicLoader.js:15:9)

at DynamicLoader.loadDynamicElements (ms-pq://pq.microsoft.com/ts/Shared/DynamicLoader.js:18:9)

at Global code (ms-pq://pq.microsoft.com/Views/FloatingDialog/FloatingDialog.htm:96:9)

at window.onerror (ms-pq://pq.microsoft.com/ts/ErrorHandler.js:5:9)

Answer 1

Hello AndrewSmeltz,

Thank you for posting on the Microsoft Community Forums. I hope you are well.

To help you better resolve your issue, we strongly recommend that you post your issue in our Microsoft Q&A forumto learn more about your issue. with Power Query on the web. This way, the experts in these forums will be able to provide more specific information about your concern, so that you can get exactly the result you want. We want you to get exactly the information and get the result you want. We will leave this thread open in case volunteer moderators or another community member wants to participate.

We appreciate your understanding.

Sincerely

ReynaldoB

Microsoft Community Forum Moderator