Forum Discussion
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
9 Replies
- Riny_van_EekelenPlatinum Contributor
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.
- RubenDBCopper Contributor
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
- SergeiBaklanDiamond Contributor
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