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.
Let’s connect to Spark data source
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.
Learn more about Privacera and Databricks
