Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Load Error

Hi there,

 

when the data is loading, I got following error:

After clicking "View errors", following window comes out:

these steps seemed automatically added.

Then if I remove all the steps and keep only Source, click Close and apply, all data can be loaded without error.

 

Could you please advise the reason? any impact? how to avoid the error comes again?

 

Thanks in advance.

H

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    You are supposed to consume the result of "View errors" and identify the column that caused the error. Once you corrected the issue you can delete the error group.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi lbendlin , thanks for reply, however, there is no error (IMO) in any columns. I assume it's because some column type are automatically identified by the PowerBI so that while loading data, power bi considers some "errors" are in the columns?

      Do you have advice how to change the setting so that power bi will not automatically identify the type of data?

      Thanks.

       

      H

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago
        however, there is no error (IMO) in any columns

        Well, Power Query disagrees with you. There are errors.  Look at the error table, scroll horizontally through all columns and one of them with say "Error". Click next to the Error to see the detailed explanation.