Skip to main content
Microsoft Idea

    Power BI

    New

    Passing Parameter in Source SQL with Direct Query connection

    Vote (7) Share
    Paramjit Singla's profile image

    Paramjit Singla on 01 Oct 2021 15:48:29

    We have SQL queries that returned billions of data and took hours to complete.

    Passing runtime parameter in source sql will help to reduce the data on Power BI and will improve the performance. And give more flexibility to end users to pass the values run time.

    Paginated Report have this functionality but there are many other limitations.

    Please vote if you also want this to be implemented in Power BI.

    Comments (1)
    Paramjit Singla's profile image Profile Picture

    Rohit Babber on 01 Oct 2021 15:51:57

    RE: Passing Parameter in Source SQL with Direct Query connection

    A must needed Item when migrating reports from Tableau to Power BI