Why does my CSV upload show the wrong column types?

Asked Viewed 32 times Solved
0

Numbers in my CSV are being treated as text, so I can't sum them. How do I fix it?

Connectors and data DAX and Transform AI Insights 365 Team

1 answer

0
Accepted answer

Usually the column has stray text (like 'N/A' or thousands separators in quotes). Clean those rows, or change the column type in Transform; the step is saved so it applies on every refresh.

More detail: No-code data transforms

AI Insights 365 Team ·

Your answer

Know the answer? Sign in to help. It's free.