Using a Parameter as a Data Source

[JamesCarnegie]

I have a parameter that changes depending on the value of a different parameter. I am trying to have it so this paramater will be treated as if it were typed in and not simply displayed as text. The image is the source step of a blank query.

Alternatively, it would also work if I could solve the problem below:

It seems that having quotations within the quotations is what is causing the problem. 

Help would be much appreciated. Have a nice day 🙂

[v-zhangti]

Hi, @JamesCarnegie 

Please refer to the following link, hope it can help you.

https://www.tessellationtech.io/how-to-parameterize-data-sources-power-bi/ 

https://community.powerbi.com/t5/Desktop/Dynamic-Data-Source-based-on-parameter/m-p/260077 

https://community.powerbi.com/t5/Desktop/Change-query-source-with-a-parameter/m-p/381145 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JamesCarnegie · Accepted solution]

Thank you for your response. I was able to make it work using if statements depending on the parameter value.