Database update problem when using On Premises Data Gateway MashupHttpWebResponse

[heikki_nurmi]

We have several data loads from databases (MySQL, Oracle) using Enterprise on premises data gateway. Load have been completed succesfully for months.  However, starting on Friday 21st February 2020 none of the data loads are not completed.

Error message: "Error: Unable to cast object of type 'System.Net.HttpWebResponse' to type 'Microsoft.Mashup.Engine1.Library.Common.MashupHttpWebResponse'".

We made some tests:

1. Data gateway cluster tests (in Power BI service) are completed succecfully

2. New data flow that connects to the database using data gateway can be created successfully. However it cannot be loaded (same error)

3. Dataflow that connects directly (data gateway is not used) to the Excel file in OneDrive is updated successfully all the time.

[heikki_nurmi · Accepted solution]

The problem does not occur anymore. Schedule data loads seems to work ok now.  

[v-xuding-msft]

Hi @heikki_nurmi ,

Glad you have solved the problem. You could accept your answer as a solution so that we can close the thread. If you have any other question, please feel free to ask.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.