ERROR WHEN CHANGING DATA SOURCE

[alexzhang1991]

The original database is an Excel file, but it was saved at some sub folder and not easy to find, so I moved the source file to desktop and changed data source in power bi, then it says 'load was cancelled by an error in loading a previous table' for every table.

Is there any possible reason for this or is there anyway to find out error log or something?

Thanks in advance!

[Anonymous · Accepted solution]

Did you check Query Editor->Advanced Editor and see if there was any file path you forgot to change?

[alexzhang1991]

Thanks, Jessica! I found one sheet missing when checking advanced editor.