Forum Discussion
Power BI report with SQL server multiple parameter
I have created a report in power BI using SQL server stored procedure with parameter.
After that I have created a parameter in power BI to accept the SQL parameter. however, in power BI it work fines for me.
But, Now how I can put the parameter using URL when I publish the report to power BI service.
I need to implement report in web portal using my be by IFrame with parameter.
So, different user see different report by using parameter.
how can I achieve this??
3 Replies
manusinghal , You need code that in iframe to control url based on user
First of all i created a stored procedure in sql server with 3 parameter.
After that i import stored procedure in my power BI desktop application, connectivity as import and pass the stored procedure name in advance option sql statement including parameter.
Like an example below.
Under advance editor tab of a table i hv setting of a table. Also created a 3 parameter with the same name.
now it will work fine for me if i edit paramter. Result is reflecting.
After publish the report i can't change the report on the basis of parameter passed in the URL.
hope this detail is sufficient for you.
amitchandak first of all thanks for your replay.
My question is report/Dashboard is not change on the basis of parameter passed in URL.
