Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This connector is owned and provided by Databricks.
Summary
| Property | Value |
|---|---|
| Connector |  Delta Sharing |
| Products | Power BI (semantic models) Power Query Online |
| Release state | General availability |
| Category | Other |
| Authentication kinds | Authentication OAuth |
| Data source kind | DeltaSharing |
| Function Reference Documentation | DeltaSharing.Contents |
Prerequisites
If you use Power BI Desktop you need to install the November release of Power BI Desktop or later. Download the latest version.
The data provider sends an activation URL from which you can download a credentials file that grants you access to the shared data.
After downloading the credentials file, open it with a text editor to retrieve the endpoint URL and the token.
For detailed information about Delta Sharing, visit Access data shared with you using Delta Sharing.
Supported capabilities
- Import
Parameters
Entry point: DeltaSharing.Contents
Required parameter count: 1
| Parameter | Display name | Required | Type | Group | Description | Sample values | Nullable |
|---|---|---|---|---|---|---|---|
| host | Delta Sharing Server URL | Yes | text | Delta Sharing Server URL | "https://example.databricks.com/api/2.0/delta-sharing/metastores/19a85dee-54bc-43a2-87ab-023d0ec16013" | false | |
| options | Advanced Options | No | nullable record | Advanced Options | true |
Fields in options
| Field | Display name | Required | Type | Group | Description | Sample values | Nullable | Optional |
|---|---|---|---|---|---|---|---|---|
| options.rowLimitHint | Row Limit (default is 1,000,000) | No | number | Advanced Options | Enforces a limit for the number of rows that can be retrieved | 1000000 | false | true |
Connect from Power Query Desktop
To connect to Databricks using the Delta Sharing connector, use the following steps:
Open Power BI Desktop.
Navigate to the Get Data menu and search for Delta Sharing.
Select the connector and then select Connect.
Enter the endpoint URL retrieved from the credentials file in the Delta Sharing Server URL field.
Optionally, in the Advanced Options tab you can set a Row Limit for the maximum number of rows you can download. This is set to 1 million rows by default.
Select OK.
In the Delta sharing authentication dialog box, provide your authentication type:
- If authenticating with bearer tokens, select Authentication from the sidebar and enter the token retrieved from the credentials file in the Bearer Token field.
- If authenticating with OIDC, select OAuth from the sidebar and then select Sign in. Sign in using your organization's identity provider credentials.
For more details about this process, visit Receive Delta Sharing shares using Open ID Connect.
Select Connect.
Connect from Power Query Online
To connect to Delta Sharing data:
Select Delta Sharing from the Power Query Connect to data source page.
In the Delta Sharing dialog, enter the Server URL. You can find this endpoint URL in the credentials file provided by the data provider.
Select the authentication kind:
- Authentication: Enter the bearer token from your credentials file.
- OAuth (OIDC): Sign in with your organizational identity provider to use OpenID Connect authentication.
Select Next to proceed.
In the Choose data page, select the tables you want to load, and then select Transform data to transform the data in Power Query Editor.
Limitations and considerations
This section describes any limitations or considerations of the Delta Sharing connector.
You need to make sure that the data loaded with the Delta Sharing connector fits in the memory of your machine. To ensure this, the connector limits the number of imported rows to the Row Limit set by the user.