Dynamic parameter for datasource connection in pbi...

Hi All,

Since some time I am trying to solve this problem:

I have to share a report via powerbi template .pbit with end users
Users must be able to edit the datasource connection details via parameter
The solution must be dynamic - not a static dropdown of available values

I tested this using a separate query (.xlsx table for now) with desired list of values to be used within the parameter. My findings are the following:

the list if vaues is dynamic - so the connection to this source is working fine
after selecting the parameter value other queries fail (databrics connection) with below message. Both are reffering the last step in PQ, which is not referencing other queries or steps.
interestingly there is also a third query (using exactly the same datasource and parameter) and it's not listed i nthe error message

Just to make it clear - this additional excel data source is only for my own testing purposes. In final shape I would store this information in databrics as well.

Could you please help me solve this or suggest any other solution?

Thank you in advance!
Best regards,
Michał