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 fine...
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.