What causes Table or View Already Exists?

Running a notebook cell that contains a CREATE TABLE statement multiple times without dropping the table first. A pipeline without IF NOT EXISTS guards re-runs after a partial failure and tries to recreate already-created tables. A materialized view with the same name already exists in the workspace

How do I fix Table or View Already Exists?

Use CREATE TABLE IF NOT EXISTS instead of CREATE TABLE to make the statement idempotent. Alternatively, drop the table first: DROP TABLE IF EXISTS , then run the CREATE statement. For pipeline activities, add a check at the start that skips table creation if the table already exists

Low severityfabric

Power BI Refresh Error:
Table or View Already Exists

What does this error mean?

A CREATE TABLE or CREATE VIEW statement in a Fabric Lakehouse notebook or pipeline failed because an object with that name already exists in the catalog. This is common when notebook cells or pipeline activities are run multiple times without idempotent create logic.

Common causes

1Running a notebook cell that contains a CREATE TABLE statement multiple times without dropping the table first
2A pipeline without IF NOT EXISTS guards re-runs after a partial failure and tries to recreate already-created tables
3A materialized view with the same name already exists in the workspace

How to fix it

1Use CREATE TABLE IF NOT EXISTS <name> instead of CREATE TABLE <name> to make the statement idempotent
2Alternatively, drop the table first: DROP TABLE IF EXISTS <name>, then run the CREATE statement
3For pipeline activities, add a check at the start that skips table creation if the table already exists

Beyond the docs

Common practitioner solutions not covered in the official documentation.

1If the existing table has stale data, use INSERT OVERWRITE or a TRUNCATE + INSERT pattern instead of recreating the table

Official documentation: https://learn.microsoft.com/en-us/fabric/data-engineering/troubleshoot-lakehouse