Help needed to pass a dynamic parameter value to a dataset when embedding a report

HI StephenL_CA,

How did you design the report? have you parameterized your stored procedure with query parameters?
You should parameterize the query parameters with your stored procedure at the first.

After you publish and embeded this report, you can use updateParameters and setFilters methods to update and interact with backend query parameters.

Sample code:

// Get a reference to the embedded report
var report = powerbi.embed(reportContainer, config);

// Define the list of parameter values
var parameterValues = [
  {
    name: "Parameter1",
    value: "Value1"
  },
  {
    name: "Parameter2",
    value: "Value2"
  }
];

// Update the parameter values
report.updateParameters(parameterValues)
  .then(function () {
    // Set the filters based on the updated parameter values
    var filters = [
      {
        $schema: "http://powerbi.com/product/schema#advanced",
        target: {
          table: "Table1",
          column: "Column1"
        },
        filterType: 1,
        operator: "In",
        values: [parameterValues[0].value]
      },
      {
        $schema: "http://powerbi.com/product/schema#advanced",
        target: {
          table: "Table2",
          column: "Column2"
        },
        filterType: 1,
        operator: "In",
        values: [parameterValues[1].value]
      }
    ];

    // Set the filters on the report
    report.setFilters(filters);
  });

Power BI embedded analytics Client APIs | Microsoft Learn

Regards,

Xiaoxin Sheng