INSERT statements using IDENTITY_INSERT must specify target columns
Microsoft lists this known issue for Data Warehouse; its status is Active. It was published on 26 August 2026.
Active1 version
Facts
- Microsoft id
1936- Status
- Active
- Products
- Data Warehouse
- Product family
- Data Warehouse
- Status
- Active
- Published
- 26 August 2026
- Issue ID
- 1936
- Status pages
- Microsoft Fabric status
- First captured by us
- (from our first import of this list)
- Microsoft last modified
- Source
- Microsoft Fabric and Power BI known issues · open the original at Microsoft
Microsoft says
IDENTITY columns require an explicit column list during INSERT operations.
What Microsoft changed
One version so far. If Microsoft edits it, each change shows here with what was removed and added.
First version we captured ·
As first seen: Active
- Status
- Active
Seen by us · Microsoft's timestamp · Microsoft's page
Incidents around this change
Possible connection
Incidents in the same services that started shortly after this change took effect. A shared service and time is not evidence that the change caused them.
- Fabric customers in the North Central US region may experience issues with capacity management operations. · started · Same service; started 4 hours before it was published
- Fabric customers may have experienced delays or intermittent issues while interacting with the service. · started · Same service; started 2 days after it was published
- Fabric customers may have experienced issues creating Data Agents and Environments, and some pipeline operations may become stuck or fail… · started · Same service; started 2 days after it was published
Related changes
Other changes for Microsoft Fabric
- Microsoft Fabric: Dropped warehouse recovery · Generally available
- Microsoft Fabric: Plan · Generally available
- Microsoft Fabric: OneLake storage tiers and lifecycle management · Generally available
- Microsoft Fabric: OneLake item-size reporting · Generally available
- Microsoft Fabric: Lakehouse Query Explorer · Generally available
- Microsoft Fabric: Resource Instance Rules for OneLake Network Security for Azure Services · Generally available
- Microsoft Fabric: Spark job monitoring · Generally available
- Microsoft Fabric: Real-Time Dashboard · Generally available
Last updated