Forum Discussion

WALEED's avatar
WALEED
Advocate II
8 years ago

Power Query/Power BI Problem with Decimals

It's very odd. I've: 1. Imported an xlsx file into Power Query 2. Did a bunch of transformations 3. Applied changes to carry over to Power BI   Some decimals get messed up! An Example: 2.01 be...
Need Help
tarman's avatar
tarman
Regular Visitor
6 years ago

Same problem querying from sql server, power query is getting decimals from nowhere.

M script:

let
    Origen = Sql.Database("rps", "rps2019"),
    dbo_View_Datos_Certificados = Origen{[Schema="dbo",Item="View_Datos_Certificados"]}[Data]
in
    dbo_View_Datos_Certificados

 Source data:

2019-11-21 08:00:00.000	3034-0	1595	9562691	9563991	1505	1560	0	0	2	0,261	0,609	0,546	0,017	0,019	0,932	0,275	0,073	NULL	NULL	0,022	0,014	0,013	0,005	0,095	0,143	96,96	0,6074

Power Query result:

21/11/2019 8:00:00	3034-0	1595	9562691	9563991	1505	1560	0	0	2	0,261000007	0,609000027	0,546000004	0,017000001	0,018999999	0,931999981	0,275000006	0,072999999	null	null	0,022	0,014	0,013	0,005	0,094999999	0,143000007	96,95999908	0,6074

 

ThomasBoulay's avatar
ThomasBoulay
Regular Visitor
6 years ago

Hi,

 

I have the same problem with MS Power Query.

I have an Excel file connected to a MS Access database.

I tried first with MS Query and a 1.8 value in Access become 1,799999952 in Excel (and same in MS Query).

So I tried with Power Query and it's the same result !

 

  • ThomasBoulay's avatar
    ThomasBoulay
    Regular Visitor
    6 years ago

    to complete my previous message: adding the round function doesn't change anything
    to solve the problem, I changed the fields in the Access table to text format...