Forum Discussion
User-entered field filter information
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"
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
3 Replies
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.
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
