cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Re: Power Query/Power BI Problem with Decimals

Spot on. I've unmarked my workaround as a solution.

Highlighted
Frequent Visitor

Re: Power Query/Power BI Problem with Decimals

Appreciate it, @WALEED!

Hopefully this will reopen the issue and someone will notice

 

Best,

 

LM

Highlighted
Regular Visitor

Re: Power Query/Power BI Problem with Decimals

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

 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors