Passing Parameter in Source SQL with Direct Query connection

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. An...