web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / There was a problem re...
Power Apps
Suggested Answer

There was a problem refreshing the dataflow. Error code: MetadataEvaluationGatewayTimeout.

(1) ShareShare
ReportReport
Posted on by YG-03011103-0 2
Hi guys, 
 
I am facing the issue of refreshing the data with dataflow. 
The error message is like "There was a problem refreshing the dataflow. Error code: MetadataEvaluationGatewayTimeout. (Request ID: 6a05873f-5ba9-4301-821e-231fabc0fe17)".

However, with the same data flow (same connection), it did work before. So I assume the gateway itself should be fine. 
Does anyone know how to solve that? 
 
Thanks!
 
 
Categories:
Building Power Apps
I have the same question (0)
  • Suggested answer
    Trait007 Profile Picture
    Trait007 303 on at
    Hi,

    The MetadataEvaluationGatewayTimeout error during a dataflow refresh typically indicates that the process of validating the dataflow's schema and metadata against the data source has taken too long and timed out. This issue can occur for several reasons, even if the same dataflow worked previously. Here's a systematic approach to troubleshoot and resolve the issue:

    1. Check Data Source Availability

    • Ensure the data source is available and responsive.
    • Test the connection to the data source outside of Power BI or Power Apps (e.g., using SQL Server Management Studio, a web browser, or other relevant tools).

    2. Inspect Dataflow Complexity

    • Large Datasets: If the data source has grown significantly, this could increase the time required for metadata evaluation.
    • Complex Queries: Optimize the queries in your dataflow to minimize computation. Avoid steps like merging, appending, or applying filters in the dataflow where possible.

    3. Gateway Performance

    • Gateway Load: Check if the on-premises data gateway is under heavy load. You can do this in the Power BI Service Gateway settings.
    • Gateway Update: Ensure the gateway is updated to the latest version.
    • Gateway Location: If the gateway is geographically far from the data source, latency could contribute to timeouts.

    4. Dataflow Settings

    • Open the dataflow and validate each query individually to identify any problematic transformations or sources.
    • Check the dataflow refresh policy. If you have incremental refresh enabled, ensure the partitions and range settings are correct.

    5. Query Folding

    • If the data source supports query folding, ensure that transformations in the dataflow can be folded back to the source. You can check this by right-clicking a query step in Power Query and seeing if "View Native Query" is enabled.

    6. Increase Gateway Timeout (Advanced)

    • If you have control over the on-premises data gateway, you can adjust the timeout settings:
      1. Open the GatewayConfig.json file on the machine hosting the gateway.
      2. Locate the MashupDefaultTimeout or MashupTimeout setting.
      3. Increase the value (e.g., from 2 minutes to 5 minutes).
      4. Restart the gateway service.

    7. Split the Dataflow

    • If your dataflow handles large or complex datasets, consider splitting it into smaller dataflows. Use one dataflow to extract and transform the data, and another to consume the transformed data.

    8. Monitor Logs

    • Enable and review the gateway logs for more detailed error information. This can help pinpoint where the timeout is occurring.

    9. Test in Power BI Desktop

    • Replicate the dataflow queries in Power BI Desktop. If they fail there as well, the issue likely lies with the source or transformations.

    10. Microsoft Support

    • If the issue persists, open a support ticket with Microsoft. Provide them with the Request ID and a description of the error.

    Preventive Measures:

    • Regularly monitor the size and complexity of your data sources.
    • Use incremental refresh when dealing with large datasets.
    • Ensure the gateway machine has sufficient resources (CPU, memory, etc.).
    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the January Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans