Forum Discussion

lemaribdb's avatar
lemaribdb
Helper II
1 year ago
Solved

Dataflow is creating complex type column in Lakehouse tables from Decimal or Currency type Yet Again

Hi, I see similar topci got resolved as it stopped hapening. But I encountered it just now, my currency type cols are becoming complex type in Lakehouse... It's using replace, properly mapped cols a...
lakehouse
  • BhaveshPatel's avatar
    BhaveshPatel
    1 year ago

    Yes that is correct. Convert the data to decimal type with precision of 2 in Delta Lake aka Lakehouse

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi lemaribdb ,

Thank you for reaching out to Microsoft Community.

Bsed on your description I understand that the columns that are Currency type in DFG2 are Complex in lakehouse.
This is a known issue and a temporary bug in Fabric Dataflow Gen2 that affected decimal and currency columns when they were written to Lakehouse tables.
Reference: Fabric known issues - Microsoft Fabric | Microsoft Learn.

If you have a Pro license, please consider raising support ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

Best Regards,
Chaithra E.