Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Mike Kromminga]

I’m building a dataflow and because of some weird header data, have to bring in all fields as text and change the type in later steps. I have Lat/Long fields with 15 digit precision, but after changing the data type to decimal number, it strips the precision and is only storing 3 digits. I don’t don’t see any spot to update and keep all the digits. Normally I wouldn’t be upset about lower precision, but with Lat/Long I’d prefer at least 5. 
Any ideas of additional M code I can add to specify precision before/after/during the data type change from text to decimal? Screen shots attached.

——————————
Mike Kromminga
Data Architect | ITA Group
——————————

[Ben Howard]

Hi Mike,

I am not seeing the same issue as you, the precision is persisted from the source file, in this case it’s a .csv file.  

——————————
Ben Howard, UK.

Please mark any answer as recommended if it helps you.
——————————
——————————————-

[Mike Kromminga]

Continued playing around with this and tried in PBI desktop as well. In Power Query/dataflow it looks like it removes precision but it actually does retain all digits. Desktop and dataflows are slightly different in how many digits they show in the editor. But once you load the model, in the data/table view in desktop you can specify the number of decimal places to show and all are available in the report view.
Turns out it wasn’t really an issue but since I haven’t moved beyond modeling yet I didn’t realize it.

——————————
Mike Kromminga
Data Architect | ITA Group
——————————
——————————————-

[Rick De groot]

Mike,

In case you bump into precision issues, it’s good to know Power Query by default uses the Double Precision Floating Point. 

In case that does not give you enough detail you can change it around to the Decimal.Precision floating point using the Precision Type. More on this you can read here: 
Power Query Precision: Avoid Rounding Errors – BI Gorilla

——————————
Rick De groot

Advance with Excel and Power BI:
https://Gorilla.bi

BI Gorilla

https://youtube.com/BIGorilla
——————————
——————————————-