Forum Discussion

brianj605's avatar
brianj605
New Member
8 years ago

Pass an iframe query string parameter to a stored procedure

I'm interested in passing a parameter from an iframe query string into a stored procedure using Power BI Report Server.  Is something like this possible?

 

For example:

 

URL: http://myserver/reports/powerbi/Sales?rs:embed=true&__parameter1__=QueryTokenValue123

 

----------------------


let
Source = Sql.Database("x", "x", [Query="exec StoredProcedureName '"& __parameter1__ & "'"])

 

Thanks,

Brian

6 Replies

    • brianj605's avatar
      brianj605
      New Member

      Hi Qiuyun Yu,

       

      Thanks for the reply.  I read the Pass filter in URL post, but it looks different than what I am trying to acheve.  From what I can tell, the Pass filter in URL post is about using a query string parameter to cause Power BI to filter data, such as filtering data returned from a stored procedure.

       

      What I am looking to do is to pass an arbitrary value (such as a token) from the query string as a parameter value of a stored procedure.  This would allow me a lot flexibility for logic to take place in the stored procedure based on a query string parameter.

       

      The query would look something like this:

      Source = Sql.Database("x", "x", [Query="exec StoredProcedureName '"& [escaped query string parameter value] & "'"])

       

      Thanks,

      Brian

  • Were you able to figure out how to do this? I need the same functionality. Is there a work around? Thanks.