topic Implement RLS in Push Dataset using API in Developer

Implement RLS in Push Dataset using API

Anonymous — Fri, 24 Apr 2020 14:33:15 GMT

We are trying to implement Row Level Security (RLS) using a push dataset (via the Power BI API). If we connect with Power BI Desktop to the pushed dataset we are unable to add a RLS role. We are also unable to configure RLS related properties in the dataset.

See:

According to the documentation we should be able to configure IsEffectiveIdentityRequired and IsEffectiveIdentityRolesRequired. If we try to set these to true we receive an error.

Error on post

Get dataset result

No config possible for roles

Re: Implement RLS in Push Dataset using API

kost — Sat, 20 Feb 2021 14:07:49 GMT

Hi, did you found a solution for RLS on embedded push datasets?

Re: Implement RLS in Push Dataset using API

ivanstankov — Wed, 28 Dec 2022 15:26:10 GMT

This issue is still relevant! Turnsout you cannot set RLS for streaming datasets, push datasets seem to still be unaccesible and the only way of creating a dataset supporting rls and something similar to streaming is through Streaming Dataflows - tool that heavily relies on Azure, creating complcations for users not hosted there.