User-entered field filter information

[Jug]

Is it possible to use directquery with a query that indicates that one of the filters of the fields selected in "where" must be indicated by the user, varying in each request? e.g. ... Where Client ID="user-entered"

[BA_Pete]

Hi @Jug ,

Just put [Client ID] into a slicer on the report page so the user can select the one they want.

Power BI will add this value to the WHERE clause in the Direct Query to the source, that's how DQ works.

Pete

[Jug]

Thank you, but from what I understand this would only be possible after the import. I wanted to know if it would be possible to put it already in the sql query at the time of import, so that I could use a field in the query that asks for user input so that BI can import with a filter.

I had this doubt because the sql query has a lot of complex relationships between the tables, without unique keys, so importing through the sql code would be a faster solution than doing all the table relationships in BI. Besides that, I would need to make an input field in the SQL query as it would be a report used several times, but changing, for example, the client's code to bring in the report only the information of one client at a time.

[BA_Pete · Accepted solution]

If you're using Direct Query then there IS NO import. The data is not imported to the data model at all. The data is requested from the source at the point of visualisation, with any page slicers, measure filters, visual contexts etc. all being included in the WHERE clause of the Direct Query.

From MS Learn:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery 

Pete