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 all,
It is insain that it cannot convert 1 to number. 1 is a number! This error comes from a column that has 1 and 0. So, I changed it to true and false as a text and still gives me the same exact same error.