Forum Discussion
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 are displaying 0s.
Both in BQ and dataflow the decimals are preserved correctly - they get lost only at the point of the dataset. The datatypes are set to fixed decimal throughout the process.
Example -
Dataflow:
Dataset:
(Data tab view)
(Power Query view)
Any ideas on what I can try to tweak to get the correct decimals in?
Regards,
Darya
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 thereObservation: 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)
6 Replies
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 thereObservation: 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)
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.
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
