DirectQuery in Power BI does not allow to send the parameters. We want to send the searched parameters from the power BI report UI through power BI direct query to backend which is not possible...
DanialR
Microsoft Employee
Microsoft EmployeeI think this technique will accomplish what you are trying to achieve. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters The table of values can be imported tables from your data source.
