topic Filter a report using query string parameters in the URL in Developer

Filter a report using query string parameters in the URL

VenkatC — Mon, 30 Sep 2024 14:47:17 GMT

"I’m working on a Power BI project where I need to build a report that serves multiple clients. I’m considering using a single dataset and applying filters via a query string (e.g., ClientID=123) combined with Row-Level Security (RLS) to restrict data access. For those who have worked with this approach, how does it scale in terms of performance and security when dealing with large datasets? Any potential drawbacks to watch out for?"

Re: Filter a report using query string parameters in the URL

lbendlin — Mon, 30 Sep 2024 17:28:57 GMT

This is a doomed approach. URL filters are the opposite of RLS. Use separate reports.

Re: Filter a report using query string parameters in the URL

VenkatC — Mon, 30 Sep 2024 17:46:29 GMT

I have a database containing client details, and I want to create a report for each client. Even though the reports will be similar, I aim to implement a single report that can be used for multiple clients. I'm exploring two methods: 1) filtering a report using query string parameters in the URL, and 2) dynamically binding datasets to a paginated report.