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 have a store procedure connected to Power Bi. The store procedure requires Parameter as Name and Gender to filter the records accordingly. I have created two Parameter in Power BI as “ParameterName” and “ParameterGender” and based on this parameter I should able to filter the store procedure dynamically.
Please find the query for Store Procedure to execute in Power BI:
let
Source = Sql.Database("LINCOIN\SQL2014", "POWERBIDS", [Query="EXEC POWERBIDS.dbo.SelectAllCustomers @name='"& ParameterName & "', @Gender='"& ParameterGender & "';"])
in
Source
Now when I pass the value in Parameters then the store procedure is executed successfully and require output is seen in the table.
Now I want to achieve the same by-passing Parameters value through URL and filter the store procedure based on values passed in URL.
For Example: I create below URL to pass the ParameterName value as James and ParameterGender value as M
The filters are applied to the report as shown in below screenshot but the store procedure is not filter according to the parameter passed through URL.
Please let me know how to execute the store procedure by parameter value passed through URL
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.