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

Hallo Ibendin,

thank your for your answer.

Can you point me to an URL, which describes how to do it  or give me a short description how to do it?

Especially I would be interested to know, where I can configure something for each query like :

Query execution time = When drilldown from page a to page b occurs / with selection

For me it looks like somehow there is a builtin limitation for all queries

Query execution time = When report is opened

Maybe I am wrong and just do not know how to do it, because of my limited Power BI knowledge.

But if it would really not be possible that would be (from my point of view) a very serious Power BI report server missing functionality and we should think about staying with Business Objects ( which is more expensive but also powerful).

Is it possible with Power BI Desktop / Power BI Report server or do I need other components? 

I played around with the parameters in "Transform data part" but was not able to get parameters into my queries.

Many thanks for your answers in advance,

Horst