Power BI dataset loses decimals when created from dataflow

[DaryaS]

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

[DaryaS · Accepted solution]

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]

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.

[KBO]

Hi @DaryaS ,

I only use Decimal Number as import into my Power Query. After loading I use the modeling tab to configure my column :).

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]

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]

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]

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