Solving an error in my report query

Hi,

Can the reason be how i created the column of all years.

So I have columns 2013, 2014 2015 2016 & 2017 uploaded out of xls files.  I need one big file to work with.

I have done this by filling in:

= Table.Combine({#"2013", #"2014", #"2015", #"2016", #"2017"})

Is this the correct way?

Maybe this is why I have the errors?  I cannot find a difference anymore with data type.

Kind regards

Deborah

Edit: I prepared this post before I noticed the previous post.

I have something to check the contents of a table, but this sould be regarded as experimental, for use at your own risk and definitely not directly with your production file.

You can find some queries in this pbix file to check the contents of a table.

The pbix file contains an example table Table1.

If you invoke function fnCheckTable for Table1, then you get a copy of the table with any values replaced by errors, if the values do not conform to the column type. In Table1 there is some text in a numeric clumn and vice versa, so these come back as errors.

You can download the pbix file, copy your table into that pbix file and run the check for your table.

I don't know how long the check will run for large tables (to be honest I think it may run quite long).

Again: this is at your own risk, but maybe it will be helpful.

I'm really curious about your findings.