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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors