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
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.