troubleshooting Question

Data type error in Excel Power Query

Avatar of Curtis Long
Curtis LongFlag for United States of America asked on
Power BIMicrosoft ExcelMicrosoft Office
15 Comments1 Solution51 ViewsLast Modified:
I am using Power Query in Excel and am getting data type errors.  I have 34 source tables that I have appended into one query.  The data from one table in the appended query gives a data type error on one column, saying that it can't convert the data to a number, even though it is set as text.  The query for that table and column is set to text and gives the same error.  The source table column is formatted as text.  Even new data entered into the source table gets the same error.  Please help!  There are no special symbols or numbers in the source data.
I have attached some of the Excel sheets I'm working with.  The 2020 Monthly Haul Sheet is one of the source files (August_2020 is the table with problems), and the MTR Report - NEW is where the query is.  I can send the other two source sheets, if needed.
Tom Farrar

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 15 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 15 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros