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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Dataflow Gen2: Lakehouse destination - Service Principal (SPN) support

Currently, the Lakehouse destination only supports Organizational account authentication.

 

This means the destination connection is depending on a specific user's account.

 

Please make it possible to use Service Principal authentication instead.

 

By going through the destination settings inside the Dataflow Gen2, I can see that the options for connecting to the various destinations are:

 

* **Lakehouse**

   * Organizational account

* **Warehouse**

   * Organizational account

   * Service Principal

* **Fabric SQL Database**

   * Organizational account

   * Service Principal

* **Azure SQL Database**

   * Basic (username/password)

   * Organizational account

   * Service Principal

   * Workspace identity

   * Note: Basic and Service Principal options can use Azure Key Vault references in this connector.

* **Azure Data Explorer**

   * Organizational account

   * Service Principal

* **SharePoint**

   * Anonymous

   * Organizational account

   * Service Principal

   * Workspace identity

* **Azure Data Lake Storage Gen2**

   * Account key

   * Organizational account

   * Shared Access Signature (SAS)

   * Service Principal

   * Workspace identity

 

(Sorry about the bad formatting).

 

The Lakehouse destination only supports Organizational account - why?

Status: Needs Votes
Comments
miguel
Community Admin
Status changed to: Needs Votes