Lock Filter created using Filter Parameter in Power BI Report Server

gagsbh — Thu, 05 Aug 2021 14:41:20 GMT

Hello All,

I have been able to implement Filter URL Parameter in Power BI Rpeort Server (On-premises)

I want to give the Report URL to our MSPs/Resellers but they need to see only thier data and not other MSPs data.
I have implemented filter parameter in the Report URL something like below:

https://reportserver/reports/powerbi/ReportName?rs:embed=true&filter=UsageDetail/MSPName eq 'MSP001'

It shows the filter on MSPName with MSP001 selected as the filter value.
However, users can also see other MSPs in the filter as well as Select All option.

I want that only the filter parameter does not show any other MSP except the one I sent in the parameter i.e. MSP001
Also, users should not be able to select "Select All" option.

Is it possible to lock the Filter created using the URL filter parameter so that use cannot edit the filter.

Regards,
Gagan

Re: Lock Filter created using Filter Parameter in Power BI Report Server

lbendlin — Thu, 05 Aug 2021 21:51:35 GMT

No, this is not possible. Security by Obscurity does not work. Implement RLS, or create separate reports in separate workspaces.

Usually Report Server is used when you DON'T want your data to leave the premises.

topic Lock Filter created using Filter Parameter in Power BI Report Server in Developer

Lock Filter created using Filter Parameter in Power BI Report Server

Re: Lock Filter created using Filter Parameter in Power BI Report Server