Forum Discussion

DaryaS's avatar
DaryaS
New Member
6 years ago
Solved

Power BI dataset loses decimals when created from dataflow

Hi All,   We load data from Google BigQuery to Power BI dataflow, on top of which a dataset is created. In the resulting dataset, all the amounts that have decimals are rounded and the decimals ar...
Need Help
Tips and Tricks
  • DaryaS's avatar
    DaryaS
    6 years ago

    For now, we fixed the problem in the following way:

    > in the dataflow, change a measure column to data type text (so you will see numbers like ##.##000000000)
    > reload the dataset
    > decimals appear and are correct
    > roll the column in the dataflow back to decimal
    > refresh the dataset again - decimals are still there

     

    Observation: in step 1, I have changed the data type only for 1 column - but after the refresh, all measures were showing their decimals correctly (even the ones without any changes in data types)

DaryaS's avatar
DaryaS
New Member
6 years ago

Hi Kathrin,

 

On the Modelling tab, the column is also set to decimal number format with 2 decimal places. Unfortunately, that doesn't resolve the issue.

 

Regards,

Darya

KBO's avatar
KBO
Icon for Memorable Member rankMemorable Member
6 years ago

Hi DaryaS ,

and th datatype in the Dataflow is also Decimal Number because in your picture the datatype is fixed decimal number...?

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

  • DaryaS's avatar
    DaryaS
    New Member
    6 years ago

    Kathrin,

    As far as I know, in dataflow there is no option to set fixed decimal as a data type, you can only pick decimal:

     

    Regards,

    Darya