Run multiple queries during drilldown and use selected elements from visual in SQL-where clause

We are trying to use Power BI Desktop / Power BI report server to display results from a big data warehouse realized in postgres. I am working on views to be used with Power BI, either with <DIRECT ...