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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Pravesh
New Member

Dataflow refresh issue with Odata

Power BI Dataflow refresh is continuously failing with the below error:

 

We are taking data from PPM Pro tool through odata connection to the dataflow. 

 

Error: Data Source Error : DataSource.Error: Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:

OData Version: 3 and 4 Error: The remote server returned an error: (500) Internal Server Error. (Exception of type 'System.OutOfMemoryException' was thrown.)

 

Does anyone have any idea on how to resolve this? Thanks in advance.

 

1 REPLY 1
jaweher899
Super User
Super User

This error message usually indicates that there is a problem with the data source or the connection to the data source. The issue may be caused by a number of factors, including insufficient memory on the server, problems with the data source configuration, or issues with the OData connection. To resolve the issue, you could try the following steps:

  1. Check the memory on the server to ensure that it has enough available memory to process the data.

  2. Check the configuration of the data source to make sure that it is set up correctly. This may include verifying the connection credentials, ensuring that the data source is accessible, and verifying the OData version being used.

  3. Try to refresh the dataflow at a different time to see if the error is related to high traffic on the data source.

  4. If possible, try to retrieve a smaller subset of data from the data source to see if the issue is related to the size of the data being retrieved.

  5. If the issue persists, consider reaching out to the support team of the PPM Pro tool for further assistance.

If the issue is related to the Power BI Gateway, it may be necessary to update the Gateway or reconfigure the connection to the data source.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors