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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
VenDaFabricator
Frequent Visitor

Writeback to Fabric Lakehouse or Warehouse from external application

We are working on use case where external application reads data from lakehouse using Service Principal credential and once it process the data need to write back with logs and results into fabric.  

 

For read, Service Principal was assigned with "Read all data using SQL (ReadData)" on Lakehouse.

To write back we got a Fabric Warehouse, how can i go assign Writer role to Service Principal so that they can write to warehouse.

 

Any clues, reference doc's would be great help.

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

The SQL endpoint is read only.  To write into the warehouse you need to use user pocesses like pipelines, DF Gen2 etc.

 

What is data warehousing in Microsoft Fabric? - Microsoft Fabric | Microsoft Learn

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

The SQL endpoint is read only.  To write into the warehouse you need to use user pocesses like pipelines, DF Gen2 etc.

 

What is data warehousing in Microsoft Fabric? - Microsoft Fabric | Microsoft Learn

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.