Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

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


Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.