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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.