https://community.fabric.microsoft.com/t5/Report-Server/With-Power-BI-report-server-May-2022-how-to-call-a-Stored/m-p/3249783#M29856 <P>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&nbsp;<BR /><BR />= Sql.Database(ServerName, DBName, [Query="exec [dbo].[MY_SP] '" &amp; Parm1 &amp; "','" &amp; Parm2 &amp; "'"])</P> Tue, 23 May 2023 21:13:20 GMT spathak04 2023-05-23T21:13:20Z https://community.fabric.microsoft.com/t5/Report-Server/With-Power-BI-report-server-May-2022-how-to-call-a-Stored/m-p/3249783#M29856 <P>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&nbsp;<BR /><BR />= Sql.Database(ServerName, DBName, [Query="exec [dbo].[MY_SP] '" &amp; Parm1 &amp; "','" &amp; Parm2 &amp; "'"])</P> Tue, 23 May 2023 21:13:20 GMT https://community.fabric.microsoft.com/t5/Report-Server/With-Power-BI-report-server-May-2022-how-to-call-a-Stored/m-p/3249783#M29856 spathak04 2023-05-23T21:13:20Z