Query Databricks from Power BI with Row Level Security

RafikiT97
New Contributor

I am trying to apply RLS to the solution but Power BI only connects to Databricks(DB) using a token which cant be used in DB groups. Is there no other way to apply Row Level security using Power BI?

daniel_sahal
Databricks MVP

@Daniel Gomes​ 

PBI RLS is independent of the data source.

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

Yes, there are roles in PowerBI, and it just adds something to the query depends which user is using it, like WHERE user_id = 199


My blog: https://databrickster.medium.com/

jose_gonzalez
Databricks Employee
Databricks Employee

Hi @Daniel Gomes​,

Just a friendly follow-up. Did any of the responses help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.