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

[christianunr]

Hello, I have a Dataflow that has been working pretty well over the past several weeks but today, after running it this morning, any column across six different tables have changed their type to complex in the Lakehouse on Fabric.

I've tried to delete the tables and create a new one from the Dataflow but the same complex type keeps appearing for these columns that are changed as a step in the Dataflow to decimal or curreny. (both transform to a complex type).

I haven't seen this before and not sure what is going on.

[john_li88]

I'm also experiencing the same issue with both Decimal and Currency columns.

[v-prasare]

Hi @christianunr, as we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[christianunr]

There wasn't really a solution provided but this issue isn't happening anymore.

[v-prasare · Accepted solution]

Hi @christianunr, Thanks for confirmation.

issue might be transient, please accept this post as solution as this will help other community memebers find similar issues quickly.

Thanks,

Prashanth

[lbendlin]

If you have a Pro license you can open a Pro 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 .

[lemaribdb]

It's happening for me right now, the columns that are Currency type in DFG2 are Complex in lakehouse