Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Power BI Dataflow - Rounding to 4 decimal places doesn't work

Dataflow > Number.Round does not allow 4 decimal places.

 

Landcrab_0-1597171599681.png

 

Change datatype to Decimal and it only shows 3 decimal places

 

Landcrab_1-1597171695264.png

 

Whereas changing it to Text shows all decimal places

 

Landcrab_2-1597171754293.png

 

 

How can this be fixed please?

 

Status: New
Comments
v-yuta-msft
Community Support

@Landcrab ,

 

Should be a by-design issue. I would suggest you create an idea here to help power bi improve.

 

Regards,

Jimmy Tao

Landcrab
Helper I

@v-yuta-msft  - not sure what you mean by 'Should be a by-design issue'??

Dataflow Power Query supports the same functionality as Power BI Desktop, correct? So why does changing a column to Decimal datatype differ between Dataflow and Desktop??

Landcrab
Helper I

Workaround - convert to TEXT datatype in Dataflow which shows all decimal places > Extract text range/ wanted number of decimal places > Connect to Dataflow in Desktop and convert column to DECIMAL datatype which then preserves the wanted number of decimal places. Hopefully Microsoft will fix the issue long term so this workaround is not needed.