Dataflow refresh issue with Odata

[Pravesh]

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.

[jaweher899]

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.