Shared Parameters

[cniemann88]

Hello, 

I am trying to share parameters across different queries. Queries are split up into different groups for usablity.

The queries i need to write are very similar, so i am trying to copy/paste them and change a few things as needed. 

Problem: When i paste all queries from a group into another, PBI adds copies of all used parameters, and overwrites the original parameters in the copied queries with the new parameter names (e.g. Parameter becomes Parameter (2) .

Question: Is there a way to force PBI to not make copies of the parameters, and just keep using the same as the original (similar to $ in excel) ? 

Thanks!

[parry2k]

@cniemann88 take your original query, and click advanced editor, copy the script,

start blank query, click advanced editor and paste the code, and from there you can make the changes to your new table.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[cniemann88]

Hey, Thanks for the reply. 

I am aware of that solution. I was hoping there was another option, right now i would have to do this 72x6 times, which would leave a lot of room for typos in the end...

Is there any other way to accomplish this? 

[cniemann88 · Accepted solution]

To circle back...i found that A solution would be to use the functions. You can generate a custom table, that contains all the variables for the function, for any of the scenarios needed. Then you can add a column as an invoked function. You can add as many functions as needed this way, as long as the parameters dont change. 

Once everything is evaluated, you can start manipulating the data to show what you need in the end.