News and Announcements icon

Power Platform CommunityForums Power Apps - Power Query Output Number as Decim...

Power Apps - Power Query

Answered

Output Number as Decimal type instead of Float type

(1) Share

Report

Report

Posted on by Eric503

28

My Dataflow will not output Decimal type numbers. For example, this Test Column is designated as Decimal:

but it puts out a Float type that I'm unable to append it to a Decimal column in an existing table.

Also, If I use the query to create a new table, the column is created as Float type instead of the expected Decimal type.

Any ideas for a fix or work around?

Categories:

General Comment

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

MS.Ragavendar 1,126 on at

Like (0)

Report
Output Number as Decimal type instead of Float type

@Eric503,

Explicitly Change Data Type in Power Query

Open your Dataflow in Power Query.

Select the column → Click Transform → Change Type → Decimal Number.

Then, apply this M code in the Advanced Editor:

Table.TransformColumns(Source, {{"Test Column", each Number.Round(_, 2), type number}}) - This ensures two decimal places and enforces a Decimal type.

Use Fixed Decimal Number Instead of Decimal Number

In Power Query, instead of using Decimal Number,

Try: Fixed Decimal Number (it uses 4 decimal places by default).

This stores values as exact Decimal (Currency format) instead of Float.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item
Michael E. Gernaey 38,415 Super User 2025 Season 1 on at

Like (0)

Report

Output Number as Decimal type instead of Float type

Hi @Eric503

Over the past 1+ there have been issues with decimals from ADF, to Data Flow in and out of GenX etc, so my guess is either.. this is just enough bug, or I would suggest trying to use the decimal(10,2) or whatever your precision needs to be in the actual flow script.

Can you share trhat here?

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,513 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,683 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans