Solved: Using a Parameter in Query String

javigold · ‎01-06-2023

I have a query string that I'm using to pull data:

[Query="SELECT ID AS OrderId, Amount AS OrderAmount from TableOrders Where StoreId = '20'"]

How do I use a parameter as the StoreId and concatenate the string? Everything I've tried has failed.

Jihwan_Kim · ‎01-06-2023

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

The parameter is created in Power Query Editor.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

javigold · ‎01-07-2023

Geez! I was making this so difficult. Thank you!

Jihwan_Kim · ‎01-06-2023

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

The parameter is created in Power Query Editor.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

Using a Parameter in Query String