Hi @mickniz, It sounds like youโre trying to connect PowerApps Dataflow to Databricks Unity Catalog using the Spark connector.
Letโs troubleshoot this issue step by step:
-
Spark Connector Configuration:
- Make sure youโre using the correct configuration for the Spark connector. You mentioned specifying an HTTP URL and using a Databricks personal access token. Letโs verify the details:
-
Databricks Personal Access Token:
- Ensure that youโve generated a valid Databricks personal access token. To create one:
- In your Databricks workspace, click your Databricks username in the top bar.
- Select โSettingsโ from the dropdown.
- Click โDeveloper.โ
- Next to โAccess tokens,โ click โManage.โ
- Click "Generate new token"2.
-
Table Visibility Issue:
- If youโre not seeing the list of tables after expanding the connection, consider the following:
- Check the permissions associated with the token. Make sure it has appropriate access to the Unity Catalog.
- Verify that the Databricks workspace youโre connecting to contains the expected tables.
- Double-check the connection details, including the server URL and token.
Remember to validate each step carefully, and if you encounter any issues, feel free to ask for further assistance. Good luck! ๐123