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 & "'"])
Stored Procedure
Hi, I've been following the below link to get a SP into Power BI with parameters and managed to get so far but when invoking I'm getting this error message: I've looked at the query and can't for the life of me see where this error is. I'm sure it's very obvious so any help would be greatly appreciated. let SQLSource = (SiteId as number, Location as text, Retailer as text) => let Source = Sql.Database("NAV17-DR2", "PW-Reports", [Query="EXEC [planning].[Supply and Demand Extra Day - Report Data '" & Number.ToText(SiteId) & "', '" & (Location) & "','" & (Retailer) & "' #(lf)#(lf)#(lf)#(lf)#(lf)#(lf)"]) in Source in SQLSource https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/ Thanks in advance
