Databricks — Table Access Restriction For BI Tools
Azure Databricks can be connected as a data source for Power BI or any other BI reporting tool and different reports can be developed based on the underneath Hive tables/Databricks Delta tables. However, reporting users may not need to know about other tables/views required for other purposes e.g. ETL loads, staging tables etc. We may also want to restrict the access of specific tables/schema to a specific set of users.
If that’s your purpose, Databricks — Table Access Control is the solution you should look for.
If you want to connect to the Databricks and want to access the Hive tables, you need the connection string and one user token. The following few steps guide how to create a connection string and use Power BI to connect to Databricks.
Construct The Databricks Connection String
The PowerBI server connection string will be something like the below:
https://<Databricks_Region>.azuredatabricks.net:443/sql/protocolv1/o/<WorkSpace_Id>/<Cluster_Id>Generate A User Token
