Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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.
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.
Well, you would need to use Power BI Embedded for this but not sure about the parameter passing.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |