Fabric Data Warehouse Deploying Tables with Identity Columns - Error SQL72014: Seed or Increment not supported

[wadegood]

• SqlPackage or DacFx Version: 2.1.0-preview.2
• .NET Framework (Windows-only) or .NET Core: 8.0.417
• Environment (local platform and source/target platforms): Ubuntu-latest

Steps to Reproduce:

1. Create a table in Fabric Data Warehouse SQL Project that contains an IDENTITY column
2. Build a DACPAC file from the SQL Project.
3. Attempt to deploy the DACPAC file.

Below is the table definition within the SQL project and the error message returned when attempting to deploy the DACPAC file. It appears that seeding is getting added to the DACPAC when the build occurs. Since Fabric Data Warehouse does not currently support seeding, this is resulting in an error.

Table Definition in SQL Project

CREATE TABLE [dwh_crm].[dbo].[DIMItem]
(
[ITEM_KEY] [bigint] IDENTITY NOT NULL,
[ITEM_NAME] varchar NULL
)
GO

Error Message:

Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 24742, Level 16, State 1, Line 1 Identity column 'ITEM_KEY' does not support specifying SEED or INCREMENT.
Error SQL72045: Script execution error. The executed script:
CREATE TABLE [dbo].[DIMItem] (
[ITEM_KEY] BIGINT IDENTITY (1, 1) NOT NULL,
[ITEM_NAME] VARCHAR (255) NULL
);

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)

[pradeepsrikakolapu]

@wadegood , the fix for this issue should be in Microsoft.Build.Sql/2.1.0-preview.3.
Could you please try again and let us know?

[wadegood]

@pradeepsrikakolapu I am still receiving the same error messages when using Microsoft.Build.Sql/2.1.0-preview.3.

[dzsquared]

@pradeepsrikakolapu - the error message is a publish error message, not a project build error message.

@wadegood - the associated fix would be in Sqlpackage and the latest preview is
https://www.nuget.org/packages/Microsoft.SqlPackage/170.3.83-preview

[wadegood]

@dzsquared Updating the SQLpackage to the version provided resulted in a successful deployment pipeline run. Thank you.

However, if I rerun the deployment pipeline, this error is returned. It appears to be related to identity insert not being supported in Fabric Data Warehouse. Should I log another bug for this?

Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 22424, Level 16, State 0, Line 9 SET IDENTITY_INSERT ON is not a supported statement type.
Error SQL72045: Script execution error. The executed script:
CREATE TABLE [dbo].[tmp_ms_xx_DIMItem] (
[ITEM_KEY] BIGINT IDENTITY NOT NULL,
[ITEM_NAME] VARCHAR (255) NULL
);

IF EXISTS (SELECT TOP 1 1
FROM [dbo].[DIMItem])
BEGIN
SET IDENTITY_INSERT [dbo].[tmp_ms_xx_DIMItem] ON;
INSERT INTO [dbo].[tmp_ms_xx_DIMItem] ([ITEM_KEY], [ITEM_NAME])
SELECT [ITEM_KEY],
[ITEM_NAME]
FROM [dbo].[DIMItem];
SET IDENTITY_INSERT [dbo].[tmp_ms_xx_DIMItem] OFF;
END

DROP TABLE [dbo].[DIMItem];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_DIMItem]', N'DIMItem';

[dzsquared]

fyi for @LeonidShutov

[pradeepsrikakolapu]

+ @dhruv ***@***.***>, There seems to be the same error that you reproduced before. Could you help on this? Pradeep Srikakolapu (pvenkat) | cloud and ai > azure data analytics > fabric > dw > product manager Please note: I am located in the pacific time zone. I send emails at times that work for me, but I do not expect responses outside your personal working hours.

…

________________________________ From: Drew Skwiers-Koballa ***@***.***> Sent: Monday, January 26, 2026 3:45 PM To: microsoft/DacFx ***@***.***> Cc: Comment ***@***.***> Subject: Re: [microsoft/DacFx] Fabric Data Warehouse Deploying Tables with Identity Columns - Error SQL72014: Seed or Increment not supported (Issue #747) fyi for @LeonidShutov<https://github.com/LeonidShutov> — Reply to this email directly, view it on GitHub<#747 (comment)> or unsubscribe<https://github.com/notifications/unsubscribe-auth/A2SM7WISGU6GIDUHYJEIEKL4I2RLHBFKMF2HI4TJMJ2XIZLTS2BKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDUOJ2WLJDOMFWWLLTXMF2GG2C7MFRXI2LWNF2HTAVFOZQWY5LFUVUXG43VMWSG4YLNMWVXI2DSMVQWIX3UPFYGLAVFOZQWY5LFVAYTEMRSG4ZDIMNENZQW2ZNIMFRXI33SL5UWJAVFOZQWY5LFVIZDCOBVGMYDOMZUGWSG4YLNMWUWQYLTL5WGCYTFNSBKK5TBNR2WLKRVGI2DENRXHE4DMN5ENZQW2ZNJNBQXGX3MMFRGK3FMON2WE2TFMN2F65DZOBS2YSLTON2WKQ3PNVWWK3TUUZ2G64DJMNZZFAVEOR4XAZNKOJSXA33TNF2G64TZUV3GC3DVMWUTENZXGYYDSOJTGGBKI5DZOBS2K2LTON2WLJLWMFWHKZNKGM4DINJXGE3TONJVU52HE2LHM5SXFJTDOJSWC5DF>. You are receiving this email because you commented on the thread. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.

[wadegood]

@dzsquared Updating the SQLpackage to the version provided resulted in a successful deployment pipeline run. Thank you.

However, if I rerun the deployment pipeline, this error is returned. It appears to be related to identity insert not being supported in Fabric Data Warehouse. Should I log another bug for this?

Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 22424, Level 16, State 0, Line 9 SET IDENTITY_INSERT ON is not a supported statement type. Error SQL72045: Script execution error. The executed script: CREATE TABLE [dbo].[tmp_ms_xx_DIMItem] ( [ITEM_KEY] BIGINT IDENTITY NOT NULL, [ITEM_NAME] VARCHAR (255) NULL );

IF EXISTS (SELECT TOP 1 1 FROM [dbo].[DIMItem]) BEGIN SET IDENTITY_INSERT [dbo].[tmp_ms_xx_DIMItem] ON; INSERT INTO [dbo].[tmp_ms_xx_DIMItem] ([ITEM_KEY], [ITEM_NAME]) SELECT [ITEM_KEY], [ITEM_NAME] FROM [dbo].[DIMItem]; SET IDENTITY_INSERT [dbo].[tmp_ms_xx_DIMItem] OFF; END

DROP TABLE [dbo].[DIMItem];

EXECUTE sp_rename N'[dbo].[tmp_ms_xx_DIMItem]', N'DIMItem';

@dzsquared @pradeepsrikakolapu is there any update on a fix for this particular bug? This is stopping us from being able to do DACPAC deployments with Fabric Data Warehouse.