Power Query does not download data separators on the web

[CarlosCiezar]

Hello,
I am trying to download data from a WEB
https://tradingeconomics.com/austria/indicators

And it doesn't download the separators properly.
Where it says 1.08 it downloads 108, and so on.
The problem is that I can't make a division for all of them because they are not all the same.
I have tried to change the data type but it doesn't change because instead of 108, it changes to 108.00.
Any solution?

Thanks and Regards

[Ahmedx]

pls try this

let
    Source = Web.BrowserContents("https://tradingeconomics.com/austria/indicators"),
    #"Extracted Table From Html" = Html.Table(Source, {{"Column1", "DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR > :nth-child(1)"}, {"Column2", "DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR > :nth-child(2)"}, {"Column3", "DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR > :nth-child(3)"}, {"Column4", "DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR > :nth-child(4)"}, {"Column5", "DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR > :nth-child(5)"}, {"Column6", "DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR > :nth-child(6)"}, {"Column7", "DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR > :nth-child(7)"}}, [RowSelector="DIV[id='overview'] > DIV.card:nth-child(1) > DIV.table-responsive > TABLE.table.table-hover > * > TR"]),
    #"Promoted Headers" = Table.PromoteHeaders(#"Extracted Table From Html", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"", type text}, {"Last", type text}, {"Previous", type text}, {"Highest", type text}, {"Lowest", type text}, {"_1", type text}, {"_2", type date}}),
    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Changed Type", {{"Previous", type number}}, "en-US"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type with Locale",{{"Last", type number}}, "en-US"),
    #"Changed Type2" = Table.TransformColumnTypes(#"Changed Type1",{{"Highest", type number}}, "en-US"),
    #"Changed Type3" = Table.TransformColumnTypes(#"Changed Type2",{{"Lowest", type number}}, "en-US")
in
    #"Changed Type3"

[CarlosCiezar]

Hello Ahmedx, 

Thanks for the reply, 

I have to reply a lot of query. I cant do this solution for each one. 

Any change for apply forever?? I have a lot of queries without this mistake.

Thanks 

[Ahmedx]

Do you have an old version of power bi?

[CarlosCiezar]

No, but at the opposite. 

It s something relative to ASCII code , or in configuration 

because in other pc was working