metricsign
Start free
Medium severityschema

Power BI Refresh Error:
1109

What does this error mean?

A multi-table DELETE statement references a table alias that is not defined in the FROM or USING clause.

Common causes

  • 1Table alias in the DELETE target list does not match the alias defined in the FROM clause
  • 2Incorrect multi-table DELETE syntax — target tables must reference aliases from the FROM/USING clause
  • 3Typo in table name or alias in a complex DELETE query

How to fix it

  1. 1Step 1: Verify multi-table DELETE syntax: `DELETE t1 FROM table1 t1 JOIN table2 t2 ON t1.id=t2.id WHERE t2.status='inactive';`
  2. 2Step 2: Ensure all table aliases in the DELETE target match those defined in the FROM or USING clause exactly.
  3. 3Step 3: Simplify to a single-table DELETE with a subquery if multi-table syntax is causing confusion: `DELETE FROM table1 WHERE id IN (SELECT id FROM table2 WHERE status='inactive');`

Frequently asked questions

What is the correct MySQL multi-table DELETE syntax?

Use: `DELETE t1 FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.fk = t2.id WHERE t2.status = 'inactive';` — the alias before FROM must match the alias in the JOIN.

Can I use a subquery instead of multi-table DELETE in MySQL?

Yes: `DELETE FROM table1 WHERE id IN (SELECT id FROM table2 WHERE status='inactive');` — simpler and avoids alias confusion.

Does ADF ever generate multi-table DELETE statements?

ADF does not generate DELETE statements in copy activities. This error would appear in ADF Script activities or Stored Procedure activities that execute custom SQL.

Official documentation: https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html

Other schema errors