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/rep...
brianj605's avatar
brianj605
New Member
8 years ago

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

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi brianj605,

     

    I'm afraid it cann't be achieved currently.  mgmeyer Do you have any idea? 

     

    Best Regards,
    Qiuyun Yu

    • brianj605's avatar
      brianj605
      New Member
      8 years ago

      Ok, thanks for letting me know,

       

      Unless @mgmeyer has a solution I'll submit it as an Idea.

       

      Thanks,

      Brian

      • tomk's avatar
        tomk
        Regular Visitor
        8 years ago

        brianj605 & v-qiuyu-msft

         

        6 months have passed since reply on this post. I want to call an JSON endpoint based on the parameter passed in query string. Is this possible in Power BI now? 

         

        I am evaluating Power BI usage and testing all features before I can commit.