Skip to main content

Power BI

New

Passing Parameter in Source SQL with Direct Query connection

Vote (8) 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