Error Message While Loading Data from Power Query into Power BI

[IduhC]

When I load a data from Power query into Power BI, it came up with an error message, 1 of the loaded queries contained errors view error. it is also showing over 18K errors and 120k

[lbendlin]

- Click on "view errors"

- go back to Power Query Editor and examine the "Errors"  group/query

- Identify the column or columns that caused the error (most likely due to type mismatch)

- correct the issue in your main query

- delete the "Errors"  group and all its queries

- Close and Apply

If no more errors then all is good.  Otherwise rinse and repeat.