Forum Discussion
Helper IILoad was cancelled by an error in loading a previous table
Issue resolved with no specific resolution.
I saved offending query M code, deleted query, recreated query using saved M code, and now it works.
I haven't see any info on how to read the Tracing logs. Can anyone say if these would hold relevant information to troubleshoot issues like these?
Sometimes the error messages in UI are not enough.
Hi,
I experienced the same error. This happens when you try to remove a column/table that is related to another table. I removed the relationship first on the tables and applied the changes.
Hope this helps.
Regards,
Helper Ifcipriano That is correct.
I removed all the models between tables and then refreshed the report and it worked.
If you are new, you can follow steps below to delete the models.
- Select the highlighted item from the left menu:
- Then you have two options to delete your models:
Option 1:
Here you can select the models manually by right clicking the connection lines between the tables and then deleting them
Method 2:
- Select th highlighted part from the top menu
- In the new windown, you may select one or multiple tables (keeping the Ctrl key down and clicking the tables) and then select delete from the bottom menu
I hope it helps other folks.