Using a Discover Endpoint with PowerBI

Discover supports the use of SQL and ODATA with PowerBI.

To use an SQL endpoint, perform the following:

1. Select ​Get Data​​​​​.
2. Using the search bar, enter "​​Databricks​​" and select ​Databricks​ from the list. Click ​Connect​  to continue.
3. Enter the following endpoint information:

• Server Hostname:​ Enter the ​SQL Host​​.
• HTTP Path:​ Enter the ​SQL HTTP Path​​.
• Default Catalog:​ Enter the ​API Catalog​​.
• Database:​ Enter the ​API Schema​​.

4. Under Data Connectivity Mode, select ​Direct Query​ and click ​OK​​  to continue.
5. Select Personal Access Token from the list on the left. Enter the user's ​Authentication Token​​​ and select ​Connect​​ .
6. On the Navigator window, select the tables (objects) to import.
7. The endpoint data is now available in PowerBI.

To use an OData endpoint, perform the following:

1. Select ​Get Data​​ ​​.
2. Using the search bar, enter "​​OData​​" and select ​OData Feed​ from the list. Click ​Connect​  to continue.
3. Leave the selection on "​​Basic​​". Enter the OData URL and select ​OK.​​
4. Select "​​Basic​​" from the list on the left. Enter the following user information and then click ​Connect :

• Username:​ Enter "​token​​".
• Password:​ Enter the user's ​Authentication Token​​.

5. On the Navigator window, select the tables (objects) to import.
6. The endpoint data is now available in PowerBI.