Sending parameters when requesting a chart.

[EvanSnapp]

I am new to Power BI and am currently evaluating it to see if it could be a suitable replacement for our current architecture. We need to render charts inside our web app and thus need to send parameters from our web app to Power BI that it should use when it queries our SQL database. In our current architecture we have a stored procedure that gets all of our report data and when we make a request to render the chart in an iframe we send it the arguments it needs to use for this stored procedure. We are now changing vendors and I was wondering if it was possible to do this in Power BI.

[Eric_Zhang]

---

@EvanSnapp wrote:

I am new to Power BI and am currently evaluating it to see if it could be a suitable replacement for our current architecture. We need to render charts inside our web app and thus need to send parameters from our web app to Power BI that it should use when it queries our SQL database. In our current architecture we have a stored procedure that gets all of our report data and when we make a request to render the chart in an iframe we send it the arguments it needs to use for this stored procedure. We are now changing vendors and I was wondering if it was possible to do this in Power BI.

---

@EvanSnapp

It is not possible to send "parameter" to a stored procedure when rendering the report. The only way no use import all data and set filter when embedding.

[Greg_Deckler]

Well, you would need to use Power BI Embedded for this but not sure about the parameter passing.