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
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.