Forum Discussion

nihal2001's avatar
nihal2001
Frequent Visitor
1 year ago
Solved

Set Parameter for parametrized report in Power BI Embedded

I am currently working on a Dynamics 365 project, where I need to use Power BI Embedded to embed reports within my clients' environments. We serve different clients across various organizations and environments. The requirement is to embed a parameterized report, which resides in my organization's workspace, into my clients' workspaces. The report will use a dynamic data source for its parameters.

Specifically, I need to know how to dynamically set the report parameters for each client during runtime in Power BI Embedded.

For example, if the parameter "OrgName" is set to "ABC" during the embedding process, the report should reflect the data source corresponding to "ABC."

To meet this requirement, we need the "OrgName" parameter to be dynamically set based on the client accessing the report, as follows:

  • For Client 1, the parameter should be set to "ABC."
  • For Client 2, the parameter should be set to "DEF."
  • For Client 3, the parameter should be set to "GHI."

This dynamic behavior is essential to ensure that each client views data specific to their respective Dynamics 365 environment, without affecting other clients.

So my ask is, how do I set the parameter of the report being embedded in runtime in Power BI Embedded?

1 Reply