Forum Discussion
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...
hi elia22gr ,
Your issue is likely a data type mismatch in the linked Dataflow. Try these fixes:
- Ensure Data Type Consistency – Set column types explicitly in both Dataflows.
- Manually Convert Columns – Use Table.TransformColumnTypes() for numbers or dates.
- Check for Non-Numeric Values – Add a custom column to detect errors:Table.AddColumn(Source, "Check", each try Number.FromText([Column]) otherwise "Error")
- Recreate the Linked Entity – Deleting and re-linking may resolve metadata issues.
- Ensure Data Type Consistency – Set column types explicitly in both Dataflows.
I deleted all the steps and rewrite the same code and worked. I was saving and refreshing it at each step.
Hi elia22gr - you can check the datatypes in dataflow like example, if any column expected to be a Number has Text values.you can set the original Calendar Dataflow to refresh first before the new Dataflow.Adjust refresh schedules to ensure the Calendar Dataflow completes before the dependent Dataflow starts. remove the link and relink the tables if necessary.
I hope the above options should helps.