Power BI error in loading a previous table: Fix it with our steps

by Tashreef Shareef
Tashreef Shareef
Tashreef Shareef
Windows & Software Expert
Tashreef Shareef is a software developer turned tech writer. He discovered his interest in technology after reading a tech magazine accidentally. Now he writes about everything tech from... read more
Affiliate Disclosure
fix Power BI error in Loading a previous Table
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

If you have a Power BI report connected to Data in an Excel file in the Power BI Service or Desktop client, you can refresh the data using the refresh button to update the table. However, some users have reported Power bi error in loading a previous table in their Power BI dashboard.

Follow the steps listed in this article to fix load was canceled by an error in loading a previous table Power BI error.

How to fix the Power BI error in loading a previous table

1. Delete and Recreate Query

power bi error in loading a previous table

  1. Start with saving the affected query M code.
  2. Next, delete the affected query from the dashboard.
  3. Now recreate the query using the previously saved M Code.
  4. Try to refresh the database again and check if the error in loading a previous table occurs again.

If the issue persists, check if any of the queries have incorrect DAX formula.

  1. If you find any incorrect DAX formula in any of the queries, delete the formula.
  2. Load the query again and check for any improvements.
  3. The error can occur due to incorrect syntax that otherwise will skip your attention.

Most users didn’t know that Microsoft Excel uses AI to turn pictures of tables into editable tables. Learn about it here.

2. Change Power BI Options

power bi error in loading a previous table

  1. From the Power BI Dashboard, go to Settings.
  2. Click on Options.
  3. Click on Data Load (this report section).
  4. Uncheck “Enable parallel loading of tables” option.
  5. Now try to load the query and check if the error is resolved.
  6. This error can also occur if the Access app cannot handle Parallel loading that we disabled earlier resulting in the error.

If the issue persists, check if you have deleted or edited a column in a referred table.

3. Undo the Changes

power bi error in loading a previous table

  1. If you are getting the error after you modified the Excel sheet related to your Power BI service, you can fix it by reverting the changes.
  2. Simply undo the changes you made to the Excel file.
  3. Make sure you revert the changes made to the Excel sheet for each query and update the tables manually to resolve the error.
  4. If the issue persists, try with Direct Query instead of Import Query when you get the data.
  5. Another reason why the error can occur is if you have changed the name for any of the tables in Excel and not in PBix. To fix this open the Advanced editor and rename the tables to match the names in Excel file.


Still having issues? Fix them with this tool:


If the advices above haven't solved your issue, your PC may experience deeper Windows problems. We recommend downloading this PC Repair tool (rated Great on TrustPilot.com) to easily address them. After installation, simply click the Start Scan button and then press on Repair All.

This article covers:Topics: