Forum Discussion
Data rows error
Hi All i am creating a report using the .txt files from Azure Data Lake storage Gen 2. When i load the data i get an error message showing some rows were loaded and there were some errors on some row...
Anonymous
Delete the last step "Changed Type" .
This should remove the error.
You will also need to figure out the root cause of the error (i.e perhaps there are letters is a column that was mostly numbers - and Power Query was 'automatically' identifying that column as Whole Numbers).
HI Anonymous
You might want to take one step at a time.
Step 1 : Add the source. Doet it error out? No, then no issue importing the file.
Step 2: Change Data type one column at a time. Eventually you will need to assign type to most of these columns. You will know which column has an issue.
will try this and update here