Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Landcrab

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

Submitted by Helper I on ‎08-11-2020 11:50 AM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
v-yuta-msft
Community Support
Community Support
‎08-12-2020 02:49 AM

@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
Helper I
‎08-12-2020 02:59 AM

@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
Helper I
‎08-16-2020 02:26 PM

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.

Idea Statuses