Excel file import issue

[gand3rson]

importing a fairly large excel xlsx file (600,000 rows) into PP - it wont work says

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

if i convert to CSV after some manipulation is works sometimes

any ideas?

 

[MD610]

I would check your field names in the excel file and be sure your are not using any common function names or SQL commands. Things like "Year", "Month", "Hour", etc. are reserved function names and depending how you might use them as a field name and then query them it could cause a problem. You can google for complete lists of SQL and DAX reserved terms.

Also, look out for special characters in your field names. The safest bet is to stick with letters, numbers, and the occasional underscore when naming fields.

 

[gand3rson]

Thank you quick question

What about year as part of the filed name

ie "Date Year"

 

[MD610]

It's possible that it could be an issue depending how it is used. Date and Year are both reserved function names. What about using DateYear? Or Date_Year? Or a different term altogether?

 

[gand3rson]

Ok I'll try changeling those names. Thnx