Create Data Export Profile Failed Error with Data Export Service

When using the Data Export Service, you may run into the following error when creating a new profile:

“Create Data Export Profile failed. Following tables or stored procedures or user-defined types with the destination prefix {0} already exist in the database: TABLE : dbo.AttributeMetadata,dbo.GlobalOptionSetMetadata,dbo.OptionSetMetadata,dbo.StateMetadata,dbo.StatusMetadata,dbo.TargetMetadata. TYPE : dbo.StateMetadataList,dbo.StatusMetadataList,dbo.OptionSetMetadataList,dbo.TargetMetadataList,dbo.AttributeMetadataList. PROCEDURE : dbo.UpsertAttributeMetadata,dbo.UpsertGlobalOptionSetMetadata,dbo.UpsertOptionSetMetadata,dbo.UpsertStateMetadata,dbo.UpsertStatusMetadata,dbo.UpsertTargetMetadata. . Please delete these database objects before you create the profile.”

In this case, these tables already exist in the Azure SQL Database. To resolve this, go to the database, and delete each table, stored procedure and type mentioned:

Click Create and Activate on the Profile again, and the objects will be recreated.

Keep learning. Keep building.

Explore AI, agents & Microsoft technology.

I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.

Subscribe on YouTube →

Carl de Souza Enterprise Architect at Microsoft · AI Technology Expert