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 & "'"])
