topic Re: Pass an iframe query string parameter to a stored procedure in Report Server

Pass an iframe query string parameter to a stored procedure

brianj605 — Sat, 04 Nov 2017 21:48:44 GMT

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

Re: Pass an iframe query string parameter to a stored procedure

v-qiuyu-msft — Mon, 06 Nov 2017 06:33:23 GMT

Hi brianj605,

It's possible to do that. Please go through Riccardo Muti (Admin, Microsoft Power BI)'s post here:

Pass filter in URL (Power BI Report Server)

Best Regards,

Qiuyun Yu

Re: Pass an iframe query string parameter to a stored procedure

brianj605 — Mon, 06 Nov 2017 15:23:33 GMT

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

Re: Pass an iframe query string parameter to a stored procedure

v-qiuyu-msft — Tue, 07 Nov 2017 07:18:05 GMT

Hi brianj605,

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

Best Regards,
Qiuyun Yu

Re: Pass an iframe query string parameter to a stored procedure

brianj605 — Tue, 07 Nov 2017 17:54:32 GMT

Ok, thanks for letting me know,

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

Thanks,

Brian

Re: Pass an iframe query string parameter to a stored procedure

tomk — Wed, 31 Jan 2018 17:25:08 GMT

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.

Re: Pass an iframe query string parameter to a stored procedure

pbibeginner5 — Thu, 15 Nov 2018 03:13:39 GMT

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