The user is creating an application in which he wants to embed Power BI.
The same Power BI report will be used in different contexts and the user wanted to have a different header each time and to provide the header as part of the URL.
There may be other ways to solve this problem(?) but as the solution was already using ADX, the user came with a way that involves Direct Query and a dynamic parameter to solve the dynamic header.
Click through to see how to solve this problem.