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

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!