Forum Discussion

RubenDB's avatar
RubenDB
Copper Contributor
Mar 19, 2021

Expression.Error the collumn from the table was not found

Dear

 

I'll make a cryptocurrencies overview for all my assets. I want to do this with data I get from a web page (coinmarketcap.com). So I make a link with my excell file. The data refreshed when I open my document. Every 5 minutes all my databases do a refresh. But then I get the error -> "Expression.Error the collumn from the table was not found".

 

Does anybody know, how can I solve this problem?

 

Thank you in advance

 

Ruben

excel

9 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 20, 2021

    RubenDB Connected to the same table as in your 2nd screenshot, with the same script (in English though).All works well and refreshing works without problems. I can, thus, not replicate your problem.

     

    But try this. Remove the "Type gewijzigd" step, so the PQ isn't looking for "Column1" to begin with. Do you really need to the step there? When I connect to the source both columns are already text, without the need for a data typing step.

    • RubenDB's avatar
      RubenDB
      Copper Contributor
      Mar 20, 2021

      Riny_van_Eekelen Thank you for your answer.

       

      I don't understand what I have to do. This is the first time that I'm working with querry's. Understand code is the script. What do I have to change on this script?

       

      let
      Bron = Web.Page(Web.Contents("https://coinmarketcap.com/currencies/cardano/")),
      Data0 = Bron{0}[Data],
      #"Type gewijzigd" = Table.TransformColumnTypes(Data0,{{"Column1", type text}, {"Column2", type text}})
      in
      #"Type gewijzigd"

       

      Only Column 2 have I need for working with.

       

      Thanks

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Mar 20, 2021

        RubenDB 

        Web site is not static, some script reload web page and update the information. In particular sequence of tables could be another. Thus as a minimum I'd suggest to take not a first table in the list, but filter it by name.

        let
    Bron = Web.Page(Web.Contents("https://coinmarketcap.com/currencies/cardano/")),
    #"Filtered Rows" = Table.SelectRows(Bron, each ([Caption] = "Cardano Price Today")),
    Data = #"Filtered Rows"{0}[Data]
in
    Data

         

Resources