Microsoft Fabric Lakehouse Upload

Received a File and uploads it to a specified location on Microsoft OneLake.

Revision History

1.0.0.0 Initial Release
1.0.0.1 Updated Upload Node to handle multiple types of input for File

Properties

Connection

Type: Connection Input

TenantId
Type: String
The Directory (tenant) ID as specified in the Entra App being used for authentication.

ClientId
Type: String
The Application (client) ID as specified in the Entra App being used for authentication.

ClientSecret
Type: Password
The Client Secret Value generated in the Entra App, this value is only displayed once when generating the Secret.

AccessToken
Type: Password
OAuth Access Token

RefreshToken
Type: Password
OAuth Refresh Token

WorkspaceId

Type: String
The Workspace identifier is used to target which workspace your Lakehouse is in.

LakehouseId

Type: String
The Lakehouse identifier is used to target the specific Lakehouse you want to upload the file to.

File

Type: Byte Array, String

The content to upload to Microsoft Fabric.

This property supports:

  • Byte Array: A binary file, typically from a File Read or File Enumerator node.
  • String: CSV-formatted content, which will be automatically encoded as UTF-8 during upload.

The node automatically detects whether the input is binary or CSV text - no manual configuration is required.

FilePath

Type: String
A relative path for where to store the file in the Lakehouse.

Remarks

Authentication

Authentication is done using Microsoft Entra. An Entra Application needs to be created to get the TenantId, ClientId, and ClientSecret that are then used in conjunction with a Microsoft login to generate an AccessToken.

Entra

WorkplaceId and LakehouseId

These can be retrieved by the user when browsing in the Fabric application: https://app.fabric.microsoft.com/groups/{WorkplaceId}/lakehouses/{LakehouseId}
While you have the Lakehouse open in the app, the URL will match the above pattern, ex. https://app.fabric.microsoft.com/groups/c45d2794-fbd7-4287-8763-1da27232f50c/lakehouses/bf45d06a-ab24-4519-a9c6-7fb2e1116b2b