Writeback to Fabric SQL — step-by-step setup for first deployment

Started by Omar Hassan · 1 year, 1 month ago · 3 replies · 1 view

Omar Hassan Participant

1 year, 1 month ago

I've set up my Planning sheet and I'm ready to configure writeback to a Fabric SQL database. The docs mention configuring under Writeback > Destination but I'm getting a connection error. My SQL database is in the same workspace.

3 Replies

Sort

Omar Hassan

Data Engineering Lead · InfraCore MENA · 1 year, 3 months ago

Got it working! The issue was that my cloud connection was using my personal OAuth token. For production, I'll switch to a service principal-based connection as recommended in the docs.

Up

0

Marcus Delacroix

Senior BI Architect · Peak Logistics Europe · 1 year, 3 months ago

Also check that your service account (or user identity) has Build permissions on the SQL database. Writeback needs write access, not just read. This is separate from the Fabric workspace role.

Up

0

Raj Subramaniam

Microsoft Fabric Consultant · CloudBridge Solutions · 1 year, 3 months ago

Make sure you've created a cloud connection to your Fabric SQL database before configuring the writeback destination. Go to the Data section and establish a connection under 'Select a Connection'. The Plan app needs an explicit connection object, even if the SQL database is in the same workspace.

Up

0