Forum Discussion
Issue with Mirroring from Cosmos DB: Decimal Values Replicated as NULL in Fabric Mirroring
Hi Rodrigol_SF,
Another workaroud is Instead of directly mirroring from the Analytical Store, route data through a Dataflow Gen2 or Spark notebook in Fabric to Ensure schema consistency before loading into a Warehouse or Lakehouse
Regards,
Vinay Pabbu
Hi Rodrigol_SF,
Thank you for reaching out to Microsoft Fabric Community Forum.
One thing you could try is adding a small pre-processing step in Cosmos DB to convert all 'Total' values to floats—so something like 6000 becomes 6000.0—before the data gets mirrored into Fabric. That helps keep the data type consistent
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu
Hi Vinay!
Thanks for your feedback. I don't think the proposed solution is entirely appropriate for our scenario, but I'll let you know if we implement it.
RegardsHi Rodrigol_SF,
Another workaroud is Instead of directly mirroring from the Analytical Store, route data through a Dataflow Gen2 or Spark notebook in Fabric to Ensure schema consistency before loading into a Warehouse or Lakehouse
Regards,
Vinay PabbuHi @Rodrigol_SF,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Vinay Pabbu
