undefined

[NoeliaLL]

I am loading CSV files. when i go to tranform data the columns are ok, divided by comas, i see the data but highlted in red as if there are erros. i try to change the format and the numers i saw turn into errors. When i close transform data i get message about cultural reference "No se admite la referencia cultural especificada". How could i solve this? is it an issue with the Csv file?

[v-saisrao-msft]

Hi @NoeliaLL,

We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.

Thank you.

[v-saisrao-msft]

Hi @NoeliaLL,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @NoeliaLL,

Have you had a chance to review the solution we shared by @lbendlin? If the issue persists, feel free to reply so we can help further.

Thank you.

[lbendlin · Accepted solution]

Try loading the query to Power BI, that might give you a better error messsage.

Look out for fields with decimal numbers ( period versus comma)  and dates (different orders of day and month).  If you know which culture the CSV files come from you can specify that culture (for example "es-MX") during the transformation.