Forum Discussion

Deborah1982's avatar
Deborah1982
New Member
8 years ago
Solved

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.   Howeve...
Need Help
  • Deborah1982's avatar
    Deborah1982
    8 years ago

    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

Deborah1982's avatar
Deborah1982
New Member
8 years ago

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

Deborah1982's avatar
Deborah1982
New Member
8 years ago

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