PowerBI and Databricks — Access Control “Privacera”

Neeraj Sabharwal
May 21 · 3 min read

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

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.

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
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

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade

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