Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Invalid identifier when loading an excel csv

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?

1 REPLY 1
MAwwad
Super User
Super User

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors