Solving an error in my report query

Question

If you normally have an error when you try to update, or refresh a query, the system shows you what the error is.

For examples duplicates, of errors in the file you have imported.

However this time I have an error, and when you click on the 'show error', the table I get is empty.

I will attach views:

1) view of the original error

2)after I click view view error, this is the screen I get

All the data that is imported in the other tables worked, this table is a combined table of all above years together.

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

There was no error first, than we updated some data in the sources, all was refreshed without errors exept this error in the combined table called 2013-2017

Answer 1

This situation typically happens when you have data that doesn't meet the column type of your table in Power Query.

An example would be decimal numbers in a column with type Int64.Type (Whole Numbers).

Power Query allows this (so there is no error in your query editor, nor in your error report), but when loading the data, errors are reported.

It may require some searching to locate the issue.

Specializing in Power Query Formula Language (M)