Forum Discussion

debosul's avatar
debosul
Frequent Visitor
2 years ago
Solved

Long runtime and NA table

Hello,

 

When I check the refresh history for a couple of dataflows gen2, I see that the first step is always like this, Table name: NA. It always takes the longest time to run compare to others table. What is this?

 

In this example it tooks only 3m but in others it can take 10-15m

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi debosul 
    Thanks for using Fabric Community.
    This is an expected behaviour.

    • Not a Physical Table: The "Table name: NA" step doesn't represent a concrete table in your dataflow. It's a placeholder for initial setup and orchestration tasks.
    • Common Tasks:
      • Initializing source connections
      • Extracting metadata
      • Optimizing dataflow logic
      • Validating data structures
      • Creating temporary staging resources

     

    •  

    Potential Reasons for Long Duration:

    • Complex Dataflows: Extensive data sources, intricate transformations, or large datasets can prolong this step.
    • External Dependencies: Reliance on external services or slow-responding systems can create delays.

    Hope this helps. Please let us know if you have any further questions.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi debosul 
    Thanks for using Fabric Community.
    This is an expected behaviour.

    • Not a Physical Table: The "Table name: NA" step doesn't represent a concrete table in your dataflow. It's a placeholder for initial setup and orchestration tasks.
    • Common Tasks:
      • Initializing source connections
      • Extracting metadata
      • Optimizing dataflow logic
      • Validating data structures
      • Creating temporary staging resources

     

    •  

    Potential Reasons for Long Duration:

    • Complex Dataflows: Extensive data sources, intricate transformations, or large datasets can prolong this step.
    • External Dependencies: Reliance on external services or slow-responding systems can create delays.

    Hope this helps. Please let us know if you have any further questions.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi debosul 
      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
      Otherwise, will respond back with the more details and we will try to help.
      Thanks