Skip to main content

    Power BI

    Needs Votes

    Parameters

    Vote (149) Share
    's profile image

    on 24 Nov 2015 11:59:59

    Execute stored procedure parameters

    Comments (15)
    's profile image Profile Picture

    605c8617 98ae-4b97-9114-d58adcccc42d on 05 Jul 2020 23:16:14

    RE: Parameters

    This needs to be available. Only passing parameters into a template when the report is opened is of little use. Should be able to use Slicers to pass the value to parameters for Stored Procs

    's profile image Profile Picture

    2760ed6c 4727-4625-a6dd-b77a9c6af700 on 05 Jul 2020 23:08:10

    RE: Parameters

    to allow for data abstraction and agnostic data sources it would be great if Power BI could easily retrieve data from stored procedures with parameters, that are easy to input by a user, not the static query option that is currently available.
    SSRS allows this option, Power BI should also.

    's profile image Profile Picture

    7cb2f4e4 c533-477c-be8e-a055b293433d on 05 Jul 2020 23:03:56

    RE: Parameters

    Crazy this doesn't exist already.

    's profile image Profile Picture

    bc2cdd56 b1db-4794-a44e-048ded6d073b on 05 Jul 2020 22:19:42

    RE: Parameters

    It would also be great to pass the parameter to an sql in Power BI

    's profile image Profile Picture

    d286acf5 20f3-45ec-9ebc-85084062bfc1 on 05 Jul 2020 22:17:42

    RE: Parameters

    This would be great as we have a number of reports that we leverage that pass parameters to a stored procedure (such as date ranges etc.) It would really open up a world of opportunities.