Forum Discussion

nareshambati's avatar
nareshambati
New Member
11 years ago

Load was cancelled by an error in loading a previous table

Hi,   I am using the new power BI desktop in Windows 7 Professional.   I have a report that is connected to data in an Excel file in my system. Sometimes, PowerBI is throwing an error when I am t...
Need Help
AlexGorev's avatar
AlexGorev
Icon for Power BI Team rankPower BI Team
11 years ago

We would love to help and address this issue! We need to reproduce this issue first... Can you share your PBIX\Excel files with us?

 

Thanks,

Alex.

nareshambati's avatar
nareshambati
New Member
11 years ago

Hi Alex,

 

Thanks for the reply.

 

I got the solution for this problem. But the reason why it appeared seems strange to me.

 

Solution:

My problem is, as I mentioned in the 1st post, a dialogue box as given below.

 

"

Refresh

Table_Name1

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

Table_Name2

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

Table_Name3

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

Table_Name4

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

.....

......

"

But my data has more than 30 tables. Somewhere in the middle of the above error it was written under Table_Name30 as  "Expression.Error: The column 'Col_Name' of the table wasn't found"

 

Yes, I deleted a column in my source data. But it seems strange to me that changes in one table was responsible for refresh error in all tables!!

 

Thank you

 

Regards,

Naresh

  • AlexGorev's avatar
    AlexGorev
    Icon for Power BI Team rankPower BI Team
    11 years ago

    Anything special about this column that was filing to load? It would be good for us to reproduce this issue? Can you share the PBIX and Excel file with the repro?

     

    Thanks,

    Alex.