cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
euthor Frequent Visitor
Frequent Visitor

Refresh issues: editing excel data source

Hi all,

as I am trying to refresh PowBI after having incremented the number of rows over 1 excel file (currently using 32 different files on this PowBI file), but since I did I can no longer have an appropriate refresh. Here's the error message I am getting:

"Load was canceled by an error in loading a previous table".

 

I already tried with changing data source (data source settings) but the error keeps top pop out.

 

Is there any viable solution which does not require to completely re-upload all the 32 files? 

 

Thanks for your help

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Refresh issues: editing excel data source

@euthor,


I suspect that all the queries in your PBIX file use data from the deleted Excel file, please go to Advanced Editor of your queries, replace the old Excel file with new Excel file in the code.

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: Refresh issues: editing excel data source

@euthor,

When you add rows in source Excel files, it doesn't require to change data source in Power BI Desktop.

You should give other detailed error messages except the above error message in Power BI Desktop during the refresh, please post all error messages here for us to troubleshoot.  

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
euthor Frequent Visitor
Frequent Visitor

Re: Refresh issues: editing excel data source

@v-yuezhe-msft

 

Here's the complete list of errors which occur when I try to refresh the PowBI file:

 

Could not find file 'F:\CrossOrg\Sales_and_Marketing\Business Intelligence\ENTRY POINT 2011\NPD\Scarico weekly BI\Weekly Master Report_PowBI [light version].xlsx'.

 

Load was cancelled by an error in loading a previous table.

 

The first one is about a file which is no longer needed to be a data source for the PowBI file, so I deleted it. Although the error message for the rest of the 33 excel files loaded keeps the same.

 

Let me please know what can I do to fix it.

 

Regards

Moderator v-yuezhe-msft
Moderator

Re: Refresh issues: editing excel data source

@euthor,


I suspect that all the queries in your PBIX file use data from the deleted Excel file, please go to Advanced Editor of your queries, replace the old Excel file with new Excel file in the code.

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
euthor Frequent Visitor
Frequent Visitor

Re: Refresh issues: editing excel data source

@v-yuezhe-msft

 

Thank you very much Lydia,

 

now everything is working fine and all reports are updated!

As I am new to PBI I am a bit lost, but now I am starting to figure it out how it works Smiley Happy

 

Thanks for your precious help!

 

Best Regards,

 

Euthor