Skip to main content

Power BI

New

Pass parameter values to embedded report

Vote (41) Share
Mike Ferris's profile image

Mike Ferris on 12 Oct 2017 22:25:48

Allow the host application to pass in a value to be applied to report parameter(s) prior to running and displaying a report. This would allow, say, a customer ID field to be assigned to a parameter ensuring only data relevant to that customer is retrieved.

Whilst this could be achieved via a URL filter, this is not considered a sufficiently secure option in our use case.

Comments (2)
Mike Ferris's profile image Profile Picture

2f1eebf0 b39d-4e64-b0b8-b182ad6b8233 on 05 Jul 2020 23:24:00

RE: Pass parameter values to embedded report

This goes to a much larger problem of ISV SaaS multi-tenancy protection in PowerBI . For instance, if ISV creates a PBI Report as a template, then allowing that template to be used by 10s of thousands of different tenants, each with their own dataset (ie CustomerID). We are struggling with this issue to "change credentials" on a dataset, so that our middleware can verify data access, and scrub data prior to PBI serving it up.

Mike Ferris's profile image Profile Picture

65b2c901 a4cf-4ad8-b09d-35722b367389 on 05 Jul 2020 23:08:57

RE: Pass parameter values to embedded report

Is there any workaround for this idea?