With Power BI report server May 2022 how to call a Stored Procedure with Parameter via URL
I have a report published on-premise server. Data source mode is import. Stored procedure has custom parameters in report. From my UI I call the URL where report is published but user want to pass parameter value and refresh the data source with those parameter value. How would I do that? How do I pass parameter value in URL and refresh the data or call the SP = Sql.Database(ServerName, DBName, [Query="exec [dbo].[MY_SP] '" & Parm1 & "','" & Parm2 & "'"])
Dynamic Parameter not updating
Hello, I have a simple report using a dynamic parameter with DirectQuery that works locally on Power BI Desktop for RS, and also works on the Power BI Service with gateway. On the report server, when I change the bound parameter on the slicer, the table looks like it's updating, and the logs show the new parameter is set, but the data does not update and continues to use the initial parameter value set. I have updated to January 2023. Are there plans to fix?