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).
Anonymous
It's probably easier to delete the step from the Power Query UI:
Otherwise you'll be chasing down comma issues.
Do not see that step in my main query
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).