Forum Discussion

elia22gr's avatar
elia22gr
Helper III
1 year ago
Solved

Dataflows: Link Entities Error in refresh

Hi all,   I have a Dataflow with Calendar Tables and it is working and refreshing normally everyday. When I created a new Dataflow where I linked a table from my Calendar's Dataflow, both not refre...
  • rohit1991's avatar
    1 year ago

    hi elia22gr ,

    Your issue is likely a data type mismatch in the linked Dataflow. Try these fixes:

    1. Ensure Data Type Consistency – Set column types explicitly in both Dataflows.

    2. Manually Convert Columns – Use Table.TransformColumnTypes() for numbers or dates.

    3. Check for Non-Numeric Values – Add a custom column to detect errors:Table.AddColumn(Source, "Check", each try Number.FromText([Column]) otherwise "Error")

    4. Recreate the Linked Entity – Deleting and re-linking may resolve metadata issues.
  • elia22gr's avatar
    1 year ago

    I deleted all the steps and rewrite the same code and worked. I was saving and refreshing it at each step.