Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
heikki_nurmi
Frequent Visitor

Database update problem when using On Premises Data Gateway MashupHttpWebResponse

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.

 

1 ACCEPTED SOLUTION
heikki_nurmi
Frequent Visitor

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

View solution in original post

2 REPLIES 2
heikki_nurmi
Frequent Visitor

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

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.

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors