Is there a way to pre-filter a powerBI report server side?

0
votes

I have uploaded a report, and using the .net SDK I've embedded said report into my website. However we show private data for many organizations. If I edit the reports iframe url to filter the report by the users org id so they can only see data for their organization then that ends up being a URL you can edit in javascript on the client side so a use could put another id there and view some other organizations data.

Is there any way possible to filter the data a report shows before it is sent client side?

I know you can edit the report file it'self but if you have hundreds of organizations, you'd need 100 copies of the same report which is obviously a maintenance and upkeep nightmare.

1
powerbipowerbi-embedded

1 Answers

1
votes

I would use the "Row Level Security" (RLS) feature for this requirement. Basically you set up roles, assign users to them and assign DAX expressions to them to filter the data.

There's a good explanation of it here:

https://azure.microsoft.com/en-us/documentation/articles/power-bi-embedded-rls/

The most efficient design of RLS (from a coding and admin perspective) is if you can feed in a username variable and filter your data by that (as shown in that example).