Invalid identifier when loading an excel csv

[Anonymous]

Hi, 

After loading a csv into power bi the rows display no values but "invalid identifier". 

My query looks as follows: 

= Table.TransformColumnTypes(#"Höher gestufte Header",{{"No.", Int64.Type}, {"Company ID", type text}, {"Company name", type text}, {"GICS", Int64.Type}, {"IQ_TOTAL_REV", type text}, {"IQ_TOTAL_REV_1", type text}, {"IQ_TOTAL_REV_2", type number}, {"IQ_TOTAL_REV_3", type number}, {"IQ_TOTAL_REV_4", type number}, {"IQ_TOTAL_REV_5", type number}, {"IQ_INVENTORY", type text}, {"IQ_INVENTORY_6", type text}, {"IQ_INVENTORY_7", type text}, {"IQ_INVENTORY_8", type text}, {"IQ_INVENTORY_9", type text}, {"IQ_INVENTORY_10", type text}, {"IQ_AR", type text}, {"IQ_AR_11", type text}, {"IQ_AR_12", type text}, {"IQ_AR_13", type text}, {"IQ_AR_14", type text}, {"IQ_AR_15", type text}, {"IQ_AP", type text}, {"IQ_AP_16", type text}, {"IQ_AP_17", type text}, {"IQ_AP_18", type text}, {"IQ_AP_19", type text}, {"IQ_AP_20", type text}, {"IQ_CASH_EQUIV", type text}, {"IQ_CASH_EQUIV_21", type text}, {"IQ_CASH_EQUIV_22", type text}, {"IQ_CASH_EQUIV_23", type text}, {"IQ_CASH_EQUIV_24", type text}, {"IQ_CASH_EQUIV_25", type text}, {"IQ_EBITDA", type text}, {"IQ_EBITDA_26", type text}, {"IQ_EBITDA_27", type text}, {"IQ_EBITDA_28", type text}, {"IQ_EBITDA_29", type text}, {"IQ_EBITDA_30", type text}, {"IQ_EBITDA_MARGIN", type text}, {"IQ_EBITDA_MARGIN_31", type text}, {"IQ_EBITDA_MARGIN_32", type text}, {"IQ_EBITDA_MARGIN_33", type text}, {"IQ_EBITDA_MARGIN_34", type text}, {"IQ_EBITDA_MARGIN_35", type text}, {"IQ_EBIT", type text}, {"IQ_EBIT_36", type text}, {"IQ_EBIT_37", type number}, {"IQ_EBIT_38", type number}, {"IQ_EBIT_39", type number}, {"IQ_EBIT_40", type number}, {"IQ_EBIT_MARGIN", type text}, {"IQ_EBIT_MARGIN_41", type text}, {"IQ_EBIT_MARGIN_42", type text}, {"IQ_EBIT_MARGIN_43", type text}, {"IQ_EBIT_MARGIN_44", type text}, {"IQ_EBIT_MARGIN_45", type number}, {"IQ_TOTAL_DEBT", type text}, {"IQ_TOTAL_DEBT_46", type text}, {"IQ_TOTAL_DEBT_47", type text}, {"IQ_TOTAL_DEBT_48", type text}, {"IQ_TOTAL_DEBT_49", type text}, {"IQ_TOTAL_DEBT_50", type text}, {"IQ_INTEREST_EXP", type text}, {"IQ_INTEREST_EXP_51", type text}, {"IQ_INTEREST_EXP_52", type text}, {"IQ_INTEREST_EXP_53", type text}, {"IQ_INTEREST_EXP_54", type text}, {"IQ_INTEREST_EXP_55", type text}, {"IQ_CAPEX", type text}, {"IQ_CAPEX_56", type text}, {"IQ_CAPEX_57", type text}, {"IQ_CAPEX_58", type text}, {"IQ_CAPEX_59", type text}, {"IQ_CAPEX_60", type text}, {"IQ_TOTAL_DIV_PAID_CF", type text}, {"IQ_TOTAL_DIV_PAID_CF_61", type text}, {"IQ_TOTAL_DIV_PAID_CF_62", type text}, {"IQ_TOTAL_DIV_PAID_CF_63", type text}, {"IQ_TOTAL_DIV_PAID_CF_64", type text}, {"IQ_TOTAL_DIV_PAID_CF_65", type text}, {"IQ_CASH_OPER", type text}, {"IQ_CASH_OPER_66", type text}, {"IQ_CASH_OPER_67", type text}, {"IQ_CASH_OPER_68", type text}, {"IQ_CASH_OPER_69", type text}, {"IQ_CASH_OPER_70", type text}, {"IQ_CASH_INVEST", type text}, {"IQ_CASH_INVEST_71", type text}, {"IQ_CASH_INVEST_72", type text}, {"IQ_CASH_INVEST_73", type text}, {"IQ_CASH_INVEST_74", type text}, {"IQ_CASH_INVEST_75", type text}, {"IQ_CASH_FINAN", type text}, {"IQ_CASH_FINAN_76", type text}, {"IQ_CASH_FINAN_77", type text}, {"IQ_CASH_FINAN_78", type text}, {"IQ_CASH_FINAN_79", type text}, {"IQ_CASH_FINAN_80", type text}})

 Any ideas how I can resolve this problem?

[MAwwad]

It looks like you are trying to load a CSV file into Power BI and transform the data types of the columns using Power Query. The error "invalid identifier" usually indicates that there is a problem with the column names in the query.

Here are a few things you can try to troubleshoot the issue:

1. Make sure that the column names in the query match the column names in the CSV file. In your query, the column names are enclosed in quotes (e.g. {"No.", Int64.Type}). Make sure that these quotes match the quotes in the CSV file.

2. Check for any typos or special characters in the column names. Power Query may not be able to recognize a column name if it contains a typo or special character.

3. Make sure that the data types specified in the query match the data in the CSV file. For example, if the "No." column in the CSV file contains text values, you will need to specify the type text data type in the query.