PowerBI and Databricks — Access Control “Privacera”

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want. Source

This article explains the integration of PowerBI with Databricks and how fine-grained access control take effect which is having table, column, and row-level access controls.

Power BI Desktop

Let’s connect to Spark data source

Spark data source
Databricks server address

You can follow this article to learn how to connect to databricks

Server address example:

The sample JDBC URL looks like

jdbc:spark://<your region>.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/xxxxxx/nnn–nn-nnn;AuthMech=3;UID=token;PWD=<personal-access-token>

modify the above into the following

https://<your region>.azuredatabricks.net:443/sql/protocolv1/o/xxxxxx/nnn–nn-nnn

Get your token from databricks cluster under user settings as listed in their blog.

PAT based authentication
Hit Connect
Metadata loading
Power BI connected to Databricks and Privacera plugin enforced Table, Row and Column masking
Audit information in Privacera Access Management audit
Policy Definition
Disable the policy
Refresh the data
Access Denied audited
Dynamic Masking policy definition
Disable the Masking policy to see clear data
Enable the Row filter
Final results

Learn more about Privacera and Databricks


Director of Sales Engineering @Privacera

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store