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 th...
Need Help
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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi lbendlin , thanks for your reply.

    After clicking on "error" in the new opened window, there was an error with warning icon, but it does not existing after I remove the steps, all the "Errors in" are common table, once click to any of the table, only 1 step "Source" since all the rest steps have been removed.

     

     

    Later the "warning icon" comes again, I will paste here and ask for further help.