Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.", In...
Need Help
Show and Tell
Tips and Tricks
MAwwad's avatar
MAwwad
Solution Sage
3 years ago

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.