Forum Discussion
cseajs
1 year agoNew Member
Error mirroring tables on Prem SQL to Fabric
We have 3 different databases on prem that I am trying to mirror to Fabric. Twenty of the tables sync with no issues but in all 3 instances there are 2 tables ( all the same tables) that are having ...
- 1 year ago
Hi cseajs ,
The error suggests that the issue is likely related to how the data is being parsed—possibly due to malformed or inconsistent structure in the source files or tables you can follow the checks suggested by mabdollahi .
Additonally, you can
1.Try loading the tables manually into OneLake and use the “Load to Table” option to see if the issue reproduces.
2. Enable raw data preview in your pipeline to inspect malformed rows.
Hope this helps!
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank you.