Forum Discussion
Append Query Errors not displaying
Hi Darren_Linc,
You want to combine the five worksheets into one dataset. From the screenshot, there are four queries work fine. The left one has an error message, right? Please upload the left one worksheet lonely, and check if it works fine.
Best Regards,
Angelia
In general, this phenomenon - errors, but an empty error report - happens when actual values conflict with column types.
Within the query editor, this is allowed and not considered an error.
When the data is loaded, those values may generate errros.
The error report however, gives no result as this is composed in Power Query where everything is considered fine.
One way to check in Power Query is add some code (or a separate query), that will raise errors also in Power Query, e.g.:
let
Source = #table(type table[Currency = Currency.Type],{{"1.234,56"},{1234.56}}),
MyTable = Table.AddIndexColumn(Source, "Index", 0, 1),
CheckCurrency = Table.TransformColumns(MyTable, {{"Currency", each try if Currency.From(_) = _ then _ else error "Invalid Value" otherwise error "Invalid value"}})
in
CheckCurrencyThis code checks if all values in the "Currency" column are of type Currency; if not, then an error is raised.
Note: each value type in Power Query has its own conversion function (Int64.From, Text.From, etcetera).