Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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:
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.