Forum Discussion
Don't execute query until user enters value
Hi lbendlin
Thanks for your response.
The requirements have changed for this, struggling to find anything online about so probably PBI still not the right tool. But here goes...
Report where I have a direct query setup, but that direct query doesn't trigger until the user enters a value? This value is then used to filter the direct query results at the point it triggers.
Hope this makes sense.
Thanks again
Super UserNow you are describing the default behavior of Direct Query. You can even go a step further.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
This is exactly what I needed, but it's only available on desktop according to that documentation 😭
- lbendlin
no, that's just where you set it up. It will function in the service as well.