Power Platform Community Forum Thread Details

Hi all,

I'm quite an error in a previously working dataflow that is absolutely vexing.

"There is a data type mismatch between the dataflow's source query column and the destination table column. The Dataverse cr434_transaction table's cr434_value column requires DecimalType data type but the dataflow contained Double data type that cannot be casted to DecimalType data type."

I'm not doing anything fancy, just combining multiple excel sheets in the dataflow with the goal of having everything recorded in a single table. I'm using an alternative key to ensure unique values. For the life of me I can't figure out why I'm getting this error.

I've double and triple checked that the datatype for all sources in the table is decimal and that they match the column datatype in dataverse.
I tried this with and without locales formatting
I then tried removing individual tables 1 by 1 to find the culprit and whichever table (or combination of tables) I use i get the same error
I can't use the currency datatype as my "cr434_value" column is part of the alternate key and that only works with decimals figures.

Is it my table that's broken?

Worst of all there isn't even a type called double in power query (Data types in Power Query - Power Query | Microsoft Learn),

I'm at my wits end. If it were a small table then I'd honestly just rebuild it, but this is an integral transaction table that already holds ~0.5M rows. and that's linked with a bunch of other tables.

Any advice is most appreciated!

Thank you

Categories:

Microsoft Dataverse with Power Apps