Forum Discussion

CarlosCiezar's avatar
CarlosCiezar
Regular Visitor
2 years ago

Power Query does not download data separators on the web

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

General Comment
Need Help
Tutorial Requests

4 Replies

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      CarlosCiezar
      Regular Visitor
      2 years ago

      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's avatar
        Ahmedx
        Icon for Super User rankSuper User
        2 years ago

        Do you have an old version of power bi?