Forum Discussion
Helper IIDataflow 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 and types etc
Yes that is correct. Convert the data to decimal type with precision of 2 in Delta Lake aka Lakehouse
7 Replies
v-echaithraCommunity Support
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.- BhaveshPatel
Super User
Not clear. Where is the dataflows currancy type col. You should give some screenshots....???
I'm experiencing same issue.
lemaribdbHi, I thought you would just trust me haha.
Lakehouse view:The actual DFG2 feed:
- BhaveshPatel
Hi lemaribdb
Databricks Delta Lake is an open source data lakehouse and implemented first even before Microsoft.
There is no data type called Currency Data Type in Delta Lake. It is decimal data type that are converted to Currency Data Type in Fabric SQL. For goodness of Microsoft
You can see the below screenshots of Delta Lake aka Lakehouse.