ADF pipeline references a stored procedure that was not deployed to the target environment. The stored procedure is in a different schema than specified (e.g. dbo vs. etl). The stored procedure was renamed or dropped after the pipeline was configured

Step 1: Verify the procedure exists: SELECT SCHEMA_NAME(schema_id) as schema_name, name FROM sys.procedures WHERE name = 'YourProcName';. Step 2: Check if it is in a different schema: SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'YourProcName';. Step 3: Update the ADF activity or the connection string to use the correct schema-qualified name: [dbo].[YourProcName].

Medium severityschema

Power BI Refresh Error:
2812

What does this error mean?

The referenced stored procedure does not exist in the target database or schema.

Common causes

1ADF pipeline references a stored procedure that was not deployed to the target environment
2The stored procedure is in a different schema than specified (e.g. dbo vs. etl)
3The stored procedure was renamed or dropped after the pipeline was configured

How to fix it

1Step 1: Verify the procedure exists: SELECT SCHEMA_NAME(schema_id) as schema_name, name FROM sys.procedures WHERE name = 'YourProcName';
2Step 2: Check if it is in a different schema: SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'YourProcName';
3Step 3: Update the ADF activity or the connection string to use the correct schema-qualified name: [dbo].[YourProcName].

Frequently asked questions

How do I list all stored procedures in a SQL Server database?

Run: SELECT SCHEMA_NAME(schema_id) as schema_name, name, create_date, modify_date FROM sys.procedures ORDER BY schema_name, name;

Can error 2812 appear in Power BI?

Yes — if a Power BI dataset uses a stored procedure as the data source query and the procedure is dropped or renamed, the refresh fails with 2812.

How do I find which ADF pipelines reference a stored procedure?

In Azure Data Factory Studio, use the Search feature to search for the procedure name across all pipelines and datasets. Alternatively, export the ARM template and grep for the procedure name.

Official documentation: https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors