Skip to main content

    Power BI

    Needs Votes

    Passing Parameters to Power BI through Stored Procedure

    Vote (238) Share
    Ankit's profile image

    Ankit on 02 Aug 2017 10:26:30

    There Should be Provision of passing the Parameter to the report like we do in SSRS Reports. There should be any method to execute Stored Procedure by passing the Parameters

    Comments (28)
    Ankit's profile image Profile Picture

    9f75d4a7 b793-4ce1-9e4a-daeda4979185 on 06 Jul 2020 00:05:35

    RE: Passing Parameters to Power BI through Stored Procedure

    Please!

    Ankit's profile image Profile Picture

    baa5a305 85b3-419d-acb5-854bc690b1e1 on 06 Jul 2020 00:04:49

    RE: Passing Parameters to Power BI through Stored Procedure

    Can't believe this isn't a feature since it has been in SSRS for years.

    Ankit's profile image Profile Picture

    16ea7a51 7234-469d-b03e-8653a5f4f6eb on 05 Jul 2020 23:59:37

    RE: Passing Parameters to Power BI through Stored Procedure

    fix the damn thing already....been waiting for this for over a year now ......!?!?!?!?
    We have a lot of customers on standby on this feature!

    Ankit's profile image Profile Picture

    1fac0baf 9610-4152-8bad-924d339565a1 on 05 Jul 2020 23:51:57

    RE: Passing Parameters to Power BI through Stored Procedure

    Lol. Vote on all the duplicate threads as per below. 'the noisy wheel...'
    Every other reporting platform can do it! Even my Grandma can do it :)

    Ankit's profile image Profile Picture

    618f25f1 e9c3-440f-8ec9-7263ee263412 on 05 Jul 2020 23:46:23

    RE: Passing Parameters to Power BI through Stored Procedure

    Cant believe by now it still not possible to use slicers and pass the value to parameter.

    Ankit's profile image Profile Picture

    0e7643b0 fad6-4230-acc5-54aeb320f2b1 on 05 Jul 2020 23:45:30

    RE: Passing Parameters to Power BI through Stored Procedure

    ​@Rose Spitzer Is there any update on this feature? Please let us know!

    Ankit's profile image Profile Picture

    a074a4a6 fb3b-46b4-91a1-e7ee7acf129c on 05 Jul 2020 23:44:30

    RE: Passing Parameters to Power BI through Stored Procedure

    This is absolutely essential, I am not sure why this has not been done till now

    Ankit's profile image Profile Picture

    cc168681 1d1c-4dc9-919b-a1565aa90771 on 05 Jul 2020 23:42:59

    RE: Passing Parameters to Power BI through Stored Procedure

    This would be handy to have. Currently I need to create view via Table Valued UDF and query the view.

    Ankit's profile image Profile Picture

    1c7a5439 757c-4c3d-8e8d-4812a0a86117 on 05 Jul 2020 23:41:14

    RE: Passing Parameters to Power BI through Stored Procedure

    I support 'Power BI Online Query Parameters' - what do you think? https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-parameters

    Ankit's profile image Profile Picture

    28ffa57d df42-4081-aca3-d9b95fa46558 on 05 Jul 2020 23:40:13

    RE: Passing Parameters to Power BI through Stored Procedure

    I frequently have to explain to our users why if Power BI Report Server is built on the SSRS engine they cannot pass parameters to a report to dynamically fetch new data sets. I don't have a good answer for them, other than "that's what Microsoft created."

    Why is this such a hard feature to add? It should work just like it does on the SSRS reports hosted on that web portal.

    Signed,

    A Frustrated Business Analyst