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.

Image for post
Image for post
Power BI Desktop

Let’s connect to Spark data source

Image for post
Image for post
Image for post
Image for post
Spark data source
Image for post
Image for post
Databricks server address

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

Server address example:

The sample JDBC URL looks like

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.

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

Learn more about Privacera and Databricks

https://blog.privacera.com/privacera-and-databricks-bring-enterprise-grade-data-governance-and-security-to-analytics-and-ml-5bef1b2cc8e5

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