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

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)

Hippo's avatar
Hippo
Frequent Visitor
5 years ago

This helped me out. I am trying to import data from MS SQL database. Data type for the column in db is float and the amount of decimals can be up to 14. When trying to use the Data Flow to import the data, It cuts down the number of decimals to 3 automatically and changes the data type to decimal as well. 

 

Using your sorcery helped me to create a workaround for this. Was a bit disappointed that I couldn't just add more decimals in Power Query.