Expression.Error the collumn from the table was not found

%3CLINGO-SUB%20id%3D%22lingo-sub-2223890%22%20slang%3D%22en-US%22%3EExpression.Error%20the%20collumn%20from%20the%20table%20was%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2223890%22%20slang%3D%22en-US%22%3E%3CP%3EDear%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'll%20make%20a%20cryptocurrencies%20overview%20for%20all%20my%20assets.%20I%20want%20to%20do%20this%20with%20data%20I%20get%20from%20a%20web%20page%20(coinmarketcap.com).%20So%20I%20make%20a%20link%20with%20my%20excell%20file.%20The%20data%20refreshed%20when%20I%20open%20my%20document.%20Every%205%20minutes%20all%20my%20databases%20do%20a%20refresh.%20But%20then%20I%20get%20the%20error%20-%26gt%3B%20%22Expression.Error%20the%20collumn%20from%20the%20table%20was%20not%20found%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20know%2C%20how%20can%20I%20solve%20this%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERuben%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2223890%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2224394%22%20slang%3D%22en-US%22%3ERe%3A%20Expression.Error%20the%20collumn%20from%20the%20table%20was%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1003131%22%20target%3D%22_blank%22%3E%40RubenDB%3C%2FA%3E%26nbsp%3BConnected%20to%20the%20same%20table%20as%20in%20your%202nd%20screenshot%2C%20with%20the%20same%20script%20(in%20English%20though).All%20works%20well%20and%20refreshing%20works%20without%20problems.%20I%20can%2C%20thus%2C%20not%20replicate%20your%20problem.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20try%20this.%20Remove%20the%20%22Type%20gewijzigd%22%20step%2C%20so%20the%20PQ%20isn't%20looking%20for%20%22Column1%22%20to%20begin%20with.%20Do%20you%20really%20need%20to%20the%20step%20there%3F%20When%20I%20connect%20to%20the%20source%20both%20columns%20are%20already%20text%2C%20without%20the%20need%20for%20a%20data%20typing%20step.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2224523%22%20slang%3D%22en-US%22%3ERe%3A%20Expression.Error%20the%20collumn%20from%20the%20table%20was%20not%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2224523%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you%20for%20your%20answer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20understand%20what%20I%20have%20to%20do.%20This%20is%20the%20first%20time%20that%20I'm%20working%20with%20querry's.%20Understand%20code%20is%20the%20script.%20What%20do%20I%20have%20to%20change%20on%20this%20script%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elet%3CBR%20%2F%3EBron%20%3D%20Web.Page(Web.Contents(%22%3CA%20href%3D%22https%3A%2F%2Fcoinmarketcap.com%2Fcurrencies%2Fcardano%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcoinmarketcap.com%2Fcurrencies%2Fcardano%2F%3C%2FA%3E%22))%2C%3CBR%20%2F%3EData0%20%3D%20Bron%7B0%7D%5BData%5D%2C%3CBR%20%2F%3E%23%22Type%20gewijzigd%22%20%3D%20Table.TransformColumnTypes(Data0%2C%7B%7B%22Column1%22%2C%20type%20text%7D%2C%20%7B%22Column2%22%2C%20type%20text%7D%7D)%3CBR%20%2F%3Ein%3CBR%20%2F%3E%23%22Type%20gewijzigd%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20Column%202%20have%20I%20need%20for%20working%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@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.

@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

@RubenDB In de lijst met toegepaste stappen: verwijder de stap "Type gewijzigd".

 

Het script komt er dan zo uit te zien:

let
Bron = Web.Page(Web.Contents("https://coinmarketcap.com/currencies/cardano/")),
Data0 = Bron{0}[Data]

in
Data0

 

 

@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

 

@Sergei Baklan Thanks Sergei

 

I have tried this modification, but now I get another error named:

"expression.error there weren't enough elements in the enumeration to complete the operation"

 

Maybe it is needed to know that I have multiple databases from a dynamic web page. You can see on the picture all my querry's.

 

Thank you for your patiently.

@Riny_van_Eekelen Bedankt voor je antwoord.

 

Ik heb dit geprobeerd maar dan wordt niet de hele tabel geladen (zie foto).

 

 

@RubenDB Both ways should work, but @Sergei Baklan 's is more robust, I would say. See attached file.

@Riny_van_Eekelen I've seen your querry scripts, I have tried this but I still have the same issue. I just sent you my file (Value's are not real). There you see my databases and the script. You should see some querry's with your script. But you see also a few scripts with @Sergei Baklan scripts. So maybe we see a difference.

 

When you refresh the querry's manually all at the same time, you should have some errors.

@RubenDB 

Afraid that's nothing to do with that. Most probably script on the site prevents to return data after few sequential requests from one source. They are pushing you to use API https://coinmarketcap.com/api/pricing/, you may try free plan but it's quite limited.