Direct query to Azure databricks delta with Row level security

[globalmc]

I have a power bi report using direct query to Azure databricks delta table , and I would like to applied also the Row level security . Is it possible to do that ? thanks 

Power BI databricks connector also support Delta table view ?

[v-chenwuz-msft]

Hi @globalmc ,

Yes, RLS is independent of the data source. You can create RLS in power bi desktop and pubilsh to service.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#define-roles-and-rules-in-power-bi...

Power BI databricks connector support Delta table view, you can connect it and see if there table view in Navigator. Or you can edit the query in power query editor or advanced sql statement to get the result by sql qurey.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.