Forum Discussion
Solving an error in my report query
HI,
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
Who can help me solve the error? I have no idea where BI is referring to?
PS: refresh is working, Close and Apply -- then the error is appearing.
This is the error messageTo view error, nothing is shown
Kind regards
Deborah
HI,
OMG you were right. There was a column in xls that should have been 123 values, and no decimals, but they did. So upload was working, but this was giving the error. Once my xls was corrected, the error was gone.
Thank you very much.
Kind regards
Deborah
6 Replies
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.
HI,
I have checked the data type, and indeed 2 columns were different from the other tables, but after fixing, still the same errors.
I think that all my columns have the correct data type.
How can I be sure?
Kind regards
Deborah
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
